How to add _2022 at the end of all the field names in a table in SAS?

[JQian]

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?

[Kurt_Bremser · Accepted solution]

memnames are always upper case, at least for datasets in BASE SAS libraries.

[JQian]

thank you so much. After I change it to upper case, it works.