topic Re: upcase character observation in a variable in SAS Programming

upcase character observation in a variable

CathyVI — Fri, 11 Sep 2020 14:31:26 GMT

Hi,

I want to make the following character observation in the character data UPCASE;

Q1_d1	Frequency
INcome	1
soc hx	1
Smoking Status	1
INCOME	1
SMOKING STATUS	1

Re: upcase character observation in a variable

ballardw — Fri, 11 Sep 2020 14:38:29 GMT

Use the upcase function in a data step.

data want;
   set have;
   q1_d1 = upcase(q1_d1);
run;

Re: upcase character observation in a variable

PGStats — Fri, 11 Sep 2020 16:51:53 GMT

If you just want to change the way the variable is displayed, give it the $UPCASE. format. This can be done in the dataset where it resides or in any proc that refers to that dataset.

proc print data=myDataset;

format Qi_d1 $UPCASE.;

run;