topic Re: Rename data set in SAS Data Science

Rename data set

RajasekharReddy — Mon, 19 Jan 2015 09:11:44 GMT

hi all,

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

reagrds,

Rajasekhar Reddy

Re: Rename data set

RW9 — Mon, 19 Jan 2015 09:29:44 GMT

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.

Re: Rename data set

Ksharp — Mon, 19 Jan 2015 10:00:29 GMT

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