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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.