Hello,
I have a dataset "nh.weekday1" that contains many variables starting with "dr1" such as "dr1drs" and "dr1_tak", I want to rename those variables starting with "wkdy", so they become "wkdydrs" and "wkdy_tak". My code and log are below. Could you please tell me what went wrong and how to fix it?
Thank you!
proc sql noprint;
select cats(name,"=",tranwrd(name,"dr1","wkdy")) into :renames separated by " "
from dictionary.columns
where libname="NH"
and memname="weekday1"
and name like "dr1";
quit;
proc datasets library=nh nolist;
modify weekday1;
rename &renames;
quit;
... View more