You never cease to amaze me - do you go to bed w/ the SAS AudioDocs playing away subliminally?

<g>

At 11:27 PM 4/5/2001 +0100, you wrote: >Hi Sharon >Having seen some posts seeking the reverse, I think you are in luck. SAS >provides several alternative solutions for what you seek. However, if it >is only for one use, that you need the upper case, then you could, as in >proc print, use the format statement > > format pt_tm $upcase.; > >or > format _character_ $upcase.; > to apply this rule to all character variables. > > > >Sharon Well <peach71_us@YAHOO.COM> writes > >Hi Everybody > > I have a several character variables in my > >dataset > >and the values (observations) for those variables are > >all in mixed case. I would like to change > >all those to caps. I am not sure if there is a > >function in sas similar to the 'UPPER' function in > >SQL. Could someone please give me some advice on how > >to accomplish this. > >Here is how the data looks now: > > > >obs PT_TM > >1 headache > >2 systolic blood pressure > >3 DIASTOLIC BLOOD PRESSURE > > > >I want to change it to > > > >obs PT_TM > >1 HEADACHE > >2 SYSTOLIC BLOOD PRESSURE > >3 DIASTOLIC BLOOD PRESSURE > > > >Thanks in advance. > > > >Sharon > > > >__________________________________________________ > >Do You Yahoo!? > >Get email at your own domain with Yahoo! Mail. > >http://personal.mail.yahoo.com/ > >-- >Peter Crawford

---------------------------------------------------------------------------- William W. Viergever Voice : (916) 483-8398 Viergever & Associates Fax : (916) 486-1488 Sacramento, CA 95835 E-mail : wwvierg@attglobal.net ----------------------------------------------------------------------------