SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Xinxin
Obsidian | Level 7

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!!

1 ACCEPTED SOLUTION

Accepted Solutions
Tom
Super User Tom
Super User

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;

View solution in original post

2 REPLIES 2
Tom
Super User Tom
Super User

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
Obsidian | Level 7

Thank you...it worked !!

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 635 views
  • 0 likes
  • 2 in conversation