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
Content-Type: text/plain; charset=ISO-8859-1
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 <email@example.com> wrote:
> Are you sure the options is varchar?
> I've tried and got the following error:
> 1 Options Varchar= Uppercase;
> ERROR 13-12: Unrecognized SAS option name, VARCHAR.
> 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>
> >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,
> >On Thu, Jun 10, 2010 at 11:44 AM, William Krause
> >> How can I Capitalize values in multiple variables in a SAS dataset (I
> >> the extensive list of variables whose values must be all upcase).
> >> Is there an efficient way to do this without specifying each variable in
> >> separate statement? Each variable has a distinct name -- there is no
> >> sequence.
> >> Thanks for your assistance.
> >> Bill K.