Hello, I have a dataset with ~200 variables. I need to rename the entire dataset with the exception of 10 variables. Previous analysts typed out each of the 190 variables, but I'm trying to streamline the code. The following is what I came up with, and works perfectly....except it renames all the variables. Can someone help me figure out how to remove just the 10 that shouldn't be renamed? Thank you. DATA dnld15;
set dnld.2015;
run;
proc sql noprint;
select cats(name,'=',name,'Z')
into :suffixlist
separated by ' '
from dictionary.columns
where libname = 'WORK' and memname = 'DNLD15' ;
quit;
proc datasets lib=WORK nolist nodetails;
modify dnld15;
rename
&suffixlist;
run;
... View more