- %macro export(libname,outfile,filename,type,dbms);
- %let libname=%upcase(&libname);
- proc sql noprint;
- select memname,count(memname) into : memlist separated by '\', : nummem
- from dictionary.tables
- where libname="&libname";
- run;
- quit;
- %do i=1 %to &nummem;
- %let memname=%scan(&memlist,&i,\);
- proc export data=&libname..&memname
- outfile="&outfile\&filename..&type"
- dbms=&dbms replace;
- sheet="&memname";
- run;
- %end;
- %mend export;
- %export(work,C:\Documents and Settings\Administrator\桌面,test,xlsx,xlsx)
稍微修改了一下,我测试了一下,工作正常。