SPSSX Discussion

conversion to upper case

Classic

List

Threaded

7 messages Options

Abbas, Zahid RQHR

conversion to upper case

Hello,

I have the data that looks like the following:

REGINA

DYSART

Regina

Regina

REGINA

SASKATOON

Fort Qu'Appelle

White City

Pilot Butte

EMERALD PARK

Is there a way to convert all to upper case?

Any help will be appreciated.

Thanks, Zahid

CONFIDENTIALITY NOTICE: The content of this e-mail and any attached
files are confidential, may contain personal health information and are
intended solely for the limited use of the named individual (s) or
entity(ies) to which they are addressed. Improper use or disclosure of
the information in this e-mail or attached files may constitute a breach
of the Health Information Act or other applicable laws and may be
subject to investigation, fines or other sanctions. If you have received
this e-mail in error, please notify the sender by return e-mail and
immedaitely destroy all originals and copies of misdirected e-mail and
attached files.

====================To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Daniel Robertson

Re: conversion to upper case

Try the upcase() function, e.g.,

string newname(a20).
compute newname = upcase(name).

Abbas, Zahid RQHR wrote:

> Hello,
>
>
>
> I have the data that looks like the following:
>
>
>
> REGINA
>
> DYSART
>
> Regina
>
> Regina
>
> REGINA
>
> SASKATOON
>
> Fort Qu'Appelle
>
> White City
>
> Pilot Butte
>
> EMERALD PARK
>
>
>
> Is there a way to convert all to upper case?
>
>
>
> Any help will be appreciated.
>
> Thanks, Zahid
>
>
>
> CONFIDENTIALITY NOTICE: The content of this e-mail and any attached
> files are confidential, may contain personal health information and are
> intended solely for the limited use of the named individual (s) or
> entity(ies) to which they are addressed. Improper use or disclosure of
> the information in this e-mail or attached files may constitute a breach
> of the Health Information Act or other applicable laws and may be
> subject to investigation, fines or other sanctions. If you have received
> this e-mail in error, please notify the sender by return e-mail and
> immedaitely destroy all originals and copies of misdirected e-mail and
> attached files.
>
>
>
> ===================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>
>

ViAnn Beadle

Re: conversion to upper case

In reply to this post by Abbas, Zahid RQHR

Use the UPPER function to compute a new string variable.

STRING newvar(a?).
COMPUTE newvar=UPPER(oldvar).

? is the same width as defined for you existing variable.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Abbas, Zahid RQHR
Sent: Thursday, November 29, 2007 8:52 AM
To: [hidden email]
Subject: conversion to upper case

Hello,

I have the data that looks like the following:

REGINA

DYSART

Regina

Regina

REGINA

SASKATOON

Fort Qu'Appelle

White City

Pilot Butte

EMERALD PARK

Is there a way to convert all to upper case?

Any help will be appreciated.

Thanks, Zahid

CONFIDENTIALITY NOTICE: The content of this e-mail and any attached
files are confidential, may contain personal health information and are
intended solely for the limited use of the named individual (s) or
entity(ies) to which they are addressed. Improper use or disclosure of
the information in this e-mail or attached files may constitute a breach
of the Health Information Act or other applicable laws and may be
subject to investigation, fines or other sanctions. If you have received
this e-mail in error, please notify the sender by return e-mail and
immedaitely destroy all originals and copies of misdirected e-mail and
attached files.

=======
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Daniel Robertson

Re: conversion to upper case

you mean UPCASE(), right ViAnn?

ViAnn Beadle wrote:

> Use the UPPER function to compute a new string variable.
>
> STRING newvar(a?).
> COMPUTE newvar=UPPER(oldvar).
>
> ? is the same width as defined for you existing variable.
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
> Abbas, Zahid RQHR
> Sent: Thursday, November 29, 2007 8:52 AM
> To: [hidden email]
> Subject: conversion to upper case
>
> Hello,
>
>
>
> I have the data that looks like the following:
>
>
>
> REGINA
>
> DYSART
>
> Regina
>
> Regina
>
> REGINA
>
> SASKATOON
>
> Fort Qu'Appelle
>
> White City
>
> Pilot Butte
>
> EMERALD PARK
>
>
>
> Is there a way to convert all to upper case?
>
>
>
> Any help will be appreciated.
>
> Thanks, Zahid
>
>
>
> CONFIDENTIALITY NOTICE: The content of this e-mail and any attached
> files are confidential, may contain personal health information and are
> intended solely for the limited use of the named individual (s) or
> entity(ies) to which they are addressed. Improper use or disclosure of
> the information in this e-mail or attached files may constitute a breach
> of the Health Information Act or other applicable laws and may be
> subject to investigation, fines or other sanctions. If you have received
> this e-mail in error, please notify the sender by return e-mail and
> immedaitely destroy all originals and copies of misdirected e-mail and
> attached files.
>
>
>
> =======
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>
>

ViAnn Beadle

Re: conversion to upper case

Probably. I used it in a reply to another question this week.

-----Original Message-----
From: Daniel Robertson [mailto:[hidden email]]
Sent: Thursday, November 29, 2007 9:42 AM
To: ViAnn Beadle
Cc: [hidden email]
Subject: Re: [SPSSX-L] conversion to upper case

you mean UPCASE(), right ViAnn?

ViAnn Beadle wrote:

Oliver, Richard

Re: conversion to upper case

UPPER is an acceptable alias for UPCASE (or vice-versa).

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of ViAnn Beadle
Sent: Thursday, November 29, 2007 10:45 AM
To: [hidden email]
Subject: Re: conversion to upper case

Probably. I used it in a reply to another question this week.

-----Original Message-----
From: Daniel Robertson [mailto:[hidden email]]
Sent: Thursday, November 29, 2007 9:42 AM
To: ViAnn Beadle
Cc: [hidden email]
Subject: Re: [SPSSX-L] conversion to upper case

you mean UPCASE(), right ViAnn?

ViAnn Beadle wrote:

--
Daniel Robertson
Senior Research and Planning Associate
Institutional Research and Planning
Cornell University, Ithaca NY 14853-2801
607.255.9642 / irp.cornell.edu

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

Daniel Robertson

Re: conversion to upper case

In reply to this post by Abbas, Zahid RQHR

Was that added in v16? I see upper() works like upcase() in v16, but it
generates an error for me in v15.

Oliver, Richard wrote:

> UPPER is an acceptable alias for UPCASE (or vice-versa).
>
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of ViAnn Beadle
> Sent: Thursday, November 29, 2007 10:45 AM
> To: [hidden email]
> Subject: Re: conversion to upper case
>
> Probably. I used it in a reply to another question this week.
>
> -----Original Message-----
> From: Daniel Robertson [mailto:[hidden email]]
> Sent: Thursday, November 29, 2007 9:42 AM
> To: ViAnn Beadle
> Cc: [hidden email]
> Subject: Re: [SPSSX-L] conversion to upper case
>
> you mean UPCASE(), right ViAnn?
>
> ViAnn Beadle wrote:
>
>> Use the UPPER function to compute a new string variable.
>>
>> STRING newvar(a?).
>> COMPUTE newvar=UPPER(oldvar).
>>
>> ? is the same width as defined for you existing variable.
>>
>> -----Original Message-----
>> From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
>> Abbas, Zahid RQHR
>> Sent: Thursday, November 29, 2007 8:52 AM
>> To: [hidden email]
>> Subject: conversion to upper case
>>
>> Hello,
>>
>>
>>
>> I have the data that looks like the following:
>>
>>
>>
>> REGINA
>>
>> DYSART
>>
>> Regina
>>
>> Regina
>>
>> REGINA
>>
>> SASKATOON
>>
>> Fort Qu'Appelle
>>
>> White City
>>
>> Pilot Butte
>>
>> EMERALD PARK
>>
>>
>>
>> Is there a way to convert all to upper case?
>>
>>
>>
>> Any help will be appreciated.
>>
>> Thanks, Zahid
>>
>>
>>
>> CONFIDENTIALITY NOTICE: The content of this e-mail and any attached
>> files are confidential, may contain personal health information and are
>> intended solely for the limited use of the named individual (s) or
>> entity(ies) to which they are addressed. Improper use or disclosure of
>> the information in this e-mail or attached files may constitute a breach
>> of the Health Information Act or other applicable laws and may be
>> subject to investigation, fines or other sanctions. If you have received
>> this e-mail in error, please notify the sender by return e-mail and
>> immedaitely destroy all originals and copies of misdirected e-mail and
>> attached files.
>>
>>
>>
>> =======
>> To manage your subscription to SPSSX-L, send a message to
>> [hidden email] (not to SPSSX-L), with no body text except the
>> command. To leave the list, send the command
>> SIGNOFF SPSSX-L
>> For a list of commands to manage subscriptions, send the command
>> INFO REFCARD
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>> [hidden email] (not to SPSSX-L), with no body text except the
>> command. To leave the list, send the command
>> SIGNOFF SPSSX-L
>> For a list of commands to manage subscriptions, send the command
>> INFO REFCARD
>>
>>
>>
>
> --
> Daniel Robertson
> Senior Research and Planning Associate
> Institutional Research and Planning
> Cornell University, Ithaca NY 14853-2801
> 607.255.9642 / irp.cornell.edu
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>
>

--
Daniel Robertson
Senior Research and Planning Associate
Institutional Research and Planning
Cornell University, Ithaca NY 14853-2801
607.255.9642 / irp.cornell.edu

--
Daniel Robertson
Senior Research and Planning Associate
Institutional Research and Planning
Cornell University, Ithaca NY 14853-2801
607.255.9642 / irp.cornell.edu

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD