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

JQian — Sun, 25 Dec 2022 22:47:42 GMT

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?

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

Kurt_Bremser — Sun, 25 Dec 2022 23:04:29 GMT

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

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

JQian — Sun, 25 Dec 2022 23:12:22 GMT

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

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

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

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

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