using a list in a macro variable to create datasets

[whijazi]

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]

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]

thanks RW9 it worked.