topic renaming a group of variables in a second data set in SAS Procedures

renaming a group of variables in a second data set

Melissa_S — Thu, 09 Oct 2014 17:38:20 GMT

I have a data set with variables. I want to rename all of those variables in a second data set and append _ADULT to all of the names but I don't want to have a big long rename statement. Does anyone know of a way to do it more easily?

Re: renaming a group of variables in a second data set

stat_sas — Thu, 09 Oct 2014 18:08:54 GMT

Try this.

proc contents data=have out=varnames(keep=name);
run;

proc sql;
select cat('rename ',trim(name),'=',trim(name),'_Adult',';') into :na separated by ' '
from varnames;
quit;

data want;
set have;
&na;
run;