Hi, I want to modify all the field names in a table by adding _2022 at the end. Using rename for all the variables would take very long. I wrote my code as this: My table name is Inforce_1906_new and it is in the WORK library, proc SQL noprint;
select cats(name,'=',name,'_2022')
into :list
separated by ' '
from dictionary.columns
where libname = 'WORK' and memname = 'Inforce_1906_New';
quit;
proc datasets library = Work nolist;
modify Inforce_1906_new;
rename &list;
contents data=Inforce_1906_new;
quit; However, when I ran the code, the SQL seemed to not doing anything. It has a note: "No rows were selected" in the log. And when I ran the second part to actually modify the name, it does not work. Does anyone know what is happening here or does anyone has a better way of doing it?
... View more