10-09-2014 01:38 PM
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?
10-09-2014 02:08 PM
proc contents data=have out=varnames(keep=name);
select cat('rename ',trim(name),'=',trim(name),'_Adult',';') into :na separated by ' '