renaming a group of variables in a second data set

[Melissa_S]

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?

[stat_sas]

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;