Date:         Tue, 15 Jun 2010 13:50:54 -0700
Reply-To:     SAS_learner <proccontents@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SAS_learner <proccontents@GMAIL.COM>
Subject:      Re: Capitalize values in multiple variables in a SAS dataset
Comments: To: Ya Huang <ya.huang@amylin.com>
In-Reply-To:  <201006152046.o5FGPiot000511@willow.cc.uga.edu>
Content-Type: text/plain; charset=ISO-8859-1

Ohh Ya,

You are right I missed that he wanted the value not Just the variable name,


I missed that part. Thanks Ya for correcting me

On Tue, Jun 15, 2010 at 1:46 PM, Ya Huang <ya.huang@amylin.com> wrote:

> Are you sure the options is varchar?
>
> I've tried and got the following error:
>
> 1    Options Varchar= Uppercase;
>             -------
>             13
> ERROR 13-12: Unrecognized SAS option name, VARCHAR.
> 2
> 3    data _null_;
> 4    a="UPPER and lower";
> 5    put a=;
> 6    run;
>
> a=UPPER and lower
>
>
> Are you trying to use validvarname?
>
> If validvarname is what you meant, then it is just to make the
> variable name upper case. But the original poster want the value
> to be upper case, not the name.
>
>
>
> On Tue, 15 Jun 2010 13:37:40 -0700, SAS_learner <proccontents@GMAIL.COM>
> wrote:
>
> >Hello William,
> >
> >You got Enough suggestions how to Upcase all the Variables. I am not sure
> >what exactly  you are doing and what is end purpose, But when doing SDTM
> >datasets I had to see to that all the end Variables are all Uppercase and
> >for that I mostly use global Options statement
> >
> >Options Varchar= Uppercase ;
> >
> >and do all the processing . This option would make sure what variable
> >created would be Up cased .
> >
> >If I am wrong somebody please explain if this technique is wrong,
> >
> >thanks
> >SL
> >
> >On Thu, Jun 10, 2010 at 11:44 AM, William Krause
> <wkrause2003@yahoo.com>wrote:
> >
> >> How can I Capitalize values in multiple variables in a SAS dataset (I
> have
> >> the extensive list of variables whose values must be all upcase).
> >>
> >> Is there an efficient way to do this without specifying each variable in
> a
> >> separate statement?  Each variable has a distinct name -- there is no
> >> sequence.
> >>
> >> Thanks for your assistance.
> >>
> >> Bill K.
> >>
>