topic Re: Batch variable renaming in SAS Programming

Batch variable renaming

cypher85 — Tue, 26 Nov 2013 20:16:59 GMT

Hi,

I have a question. I need to rename all of the variables in a sas dataset. I have another sas dataset that has 2 columns, the variable names, and what the variable names need to be renamed to. Is there a way for me to batch rename the variables in the one dataset based on the information contained in the other dataset, without doing it manually? Also, they are completely different names, it isn't simply adding a prefix or suffix. For example, I need to rename "_76532x2x26" to "HaveSurgery".

Re: Batch variable renaming

Tom — Tue, 26 Nov 2013 21:30:22 GMT

A simple way (if the list is small enough) is to generate a macro variable with pairs from the RENAME table.

Then you can use the list in a RENAME statement in a data step or PROC DATASETS step or even in RENAME= dataset option.

Example:

proc sql noprint ;

select catx('=',oldname,newname) into :renames separated by ' ' from RENAME ;

quit;

data want ;

set have ;

rename &renames;

run;

Re: Batch variable renaming

PaigeMiller — Wed, 27 Nov 2013 14:33:00 GMT

Executing even faster is probably

proc sql noprint ;

select catx('=',oldname,newname) into :renames separated by ' ' from RENAME ;

quit;

proc datasets nolist library=work;

modify datasetname;

rename &renames;

run;

quit;

Re: Batch variable renaming

cypher85 — Wed, 27 Nov 2013 18:42:43 GMT

Hi,

both methods work great! Thanks!