How to rename all datasets in a library at once?

DiG — Thu, 25 Apr 2019 15:07:54 GMT

Hi,

I have over 100 datasets in my library and need to add a uniform prefix to each of them, let's say 'bc_25'. Could you please share your knowledge how to do this?

Thanks.

Re: How to rename all datasets in a library at once?

ballardw — Thu, 25 Apr 2019 15:24:22 GMT

One way:

proc sql;
   create table work.control as
   /* replace 'pre' below with your prefixe*/
   select memname, catt('pre',memname) as newname
   from dictionary.tables
   /* replace JUNK below with your library 
      in capital letters
   */
   where libname='JUNK'
   ;
quit;

data _null_;
   set work.control end=lastone;
   if _n_=1 then call execute('proc datasets library=junk;');
   call execute ('change '||memname||'='||newname||';');
   if lastone then call execute('quit;');
run;

Caution: you may have issues if the length of your prefix plus the existing name exceeds 32 characters. The generated names would not be valid and this will throw errors.

if that might happen then you need to make sure that the length of the newname is not longer than 32.

Re: How to rename all datasets in a library at once?

DiG — Thu, 25 Apr 2019 15:51:58 GMT

Yes, it works! Thanks a lot ballardw !!

topic How to rename all datasets in a library at once? in SAS Programming

How to rename all datasets in a library at once?

Re: How to rename all datasets in a library at once?

Re: How to rename all datasets in a library at once?