Rename data set

[RajasekharReddy]

hi all,

how to rename more then two data sets in work Library by using macro

reagrds,

Rajasekhar Reddy 

[RW9]

Can you clarify why you need to use a macro, and why you would need to rename a dataset?

data new_dataset; set old_dataset; run;

If following a pattern then:

data _null_;

     set sashelp.vtable (where=(libname="XYZ" and substr(memname ,1,3)="ABC"));

     call exexcute('data DEF_'||strip(memname,4)||'; set ABC_'||strip(memname,4)||'; run;');

run;

This will rename every dataset in XYZ with the prefix ABC to have the prefix DEF.

[Ksharp]

No need Macro.

data _null_;
 set sashelp.vmember(where=(libname='WORK' and memtype='DATA')) end=last;
if _n_ eq 1 then call execute('proc datasets library='||libname||' nolist nodetails; change ');
call execute(strip(memname)||'=want'||strip(_n_));
if last then call execute(';quit;');
run;

Xia Keshan