sas表

shiyiming

如何将sas中work下的多个表批量导成excel表呢？

shiyiming

Try this:

%macro dump(file, where);
PROC EXPORT
   DATA=&file
   OUTFILE="&where.\&file"
   DBMS=excel REPLACE;
RUN;
%mend;
data _null_;
set sashelp.vtable;
call execute('%dump('||memname||', c:\ExcelTable)');
where libname='WORK';
run;