topic Re: How to Change Variable name in SAS Programming

How to Change Variable name

Kalai2008 — Tue, 01 May 2018 16:10:24 GMT

Hello,

I need a help changing the Variable name from upper case to Lower case, but not the values in that column. I have more than 200 columns and one of them needs to be in lower case instead of upper case. Example ( TOTAL_COUNT to total_count) I only have the dataset available.

Thanks for looking.

Re: How to Change Variable name

Astounding — Tue, 01 May 2018 16:16:42 GMT

Have you tried:

data want;

retain total_count;

set have;

run;

Re: How to Change Variable name

novinosrin — Tue, 01 May 2018 16:22:11 GMT

proc contents data =have out=_have;
run;

proc sql;
select lowcase(name) into : name separated by ' '
from _have;
quit;

data want;
retain &name;
set have;
run;

Re: How to Change Variable name

Kalai2008 — Tue, 01 May 2018 16:25:54 GMT

Awesome !Thank you so much..It worked !

Re: How to Change Variable name

Kalai2008 — Tue, 01 May 2018 16:27:05 GMT

Thank you so much.. It worked