Rename columns by adding sequence of numbers as suffix

[qw213]

I am trying to rename all the columns by adding a sequence as suffix. For example, right now my column names are A B C... and I want to rename them to var1 var2 var3...

Is there a way to do it? Thanks!

[Reeza · Accepted solution]

There are many ways. If you have a few it's likely easier to manually do it. If you have a large amount then a macro variable is nice. Here's an example:

Modify this to use your libname and data set name. Check to ensure the case matches.

proc sql noprint;
select catx("=", name, catt('VAR', put(varnum, 2. -l)))
into :rename_list
separated by " "
from sashelp.vcolumn
where libname='WORK'
and memname='SAMPLE';
quit;


%put &rename_list;


proc datasets library=work nodetails nolist;
modify sample;
rename &rename_list;
run; quit;

proc print data=sample noobs;
run;

---

@qw213 wrote:

I am trying to rename all the columns by adding a sequence as suffix. For example, right now my column names are A B C... and I want to rename them to var1 var2 var3...

Is there a way to do it? Thanks!

---

[qw213]

Yes this is exactly what I am looking for. Thank you!