topic Re: Renaming datasets by an array ?? in SAS Programming

Renaming datasets by an array ??

Xinxin — Wed, 24 Apr 2013 14:07:56 GMT

I have 66 datasets namely, Plan_1, Plan_2 ....... , Plan_66

I want to rename them to -- _2013_010_plan_sas, _2013_020_plan_sas, etc...there is no sequential order to these numbers, so I put them in an array,

array names{*} _2013_010_Plan_SAS

_2013_020_Plan_SAS

_2013_265_Plan_SAS

_2013_332_Plan_SAS .......;

But how do I use this array to rename the datasets via a macro, maybe.............or if there is any other way, please let me know.

Thanks, in advance!!

Tom — Wed, 24 Apr 2013 14:22:45 GMT

You need to generate code but a macro is not needed.

It will be easy read the new names as input DATA can generate the corresponding old name based on the location in the list.

data renames ;

input newname $32. ;

n+1;

oldname = catx('_','plan',n);

cards;

_2013_010_Plan_SAS

_2013_020_Plan_SAS

...

run;

proc sql noprint ;

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

from renames

;

quit;

proc datasets nolist lib=work;

change &renames ;

run; quit;

Xinxin — Wed, 24 Apr 2013 15:51:37 GMT

Thank you...it worked !!