topic Re: using a list in a macro variable to create datasets in SAS Procedures

using a list in a macro variable to create datasets

whijazi — Thu, 16 Apr 2015 14:03:37 GMT

I would like to create a permanent datasets that contains the first 1000 records of all the datasets in the work directory. I came up with this code:

%let workdsets =

will,

tom,

danny,

timmy

;

data datas.&workdsets._1000;
set work.&workdsets. (obs=1000);
run;

proc export data = datas.&workdsets._1000
outfile = "/xxx/xxxx/xxx/&workdsets._1000.csv"
dbms = csv replace;
run;

it didnt work. what can I do to efficiently create those data sets.

thanks,

will

RW9 — Thu, 16 Apr 2015 14:19:43 GMT

Well:

data _null_;

set sashelp.vtable (where=(libname="WORK"));

call execute('proc export data=work.'||strip(memname)||' (obs=1000) outfile="...\'||strip(memname)||'.csv" dbms=csv replace; run;');

run;

The ... indicates path to location.

whijazi — Thu, 16 Apr 2015 14:43:20 GMT

thanks RW9 it worked.