Help using Base SAS procedures

renaming a group of variables in a second data set

Reply
N/A
Posts: 1

renaming a group of variables in a second data set

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?

Trusted Advisor
Posts: 1,228

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

Posted in reply to Melissa_S

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;

Ask a Question
Discussion stats
  • 1 reply
  • 143 views
  • 0 likes
  • 2 in conversation