hi all,
how to rename more then two data sets in work Library by using macro
reagrds,
Rajasekhar Reddy
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.
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.
Find more tutorials on the SAS Users YouTube channel.