SAS批量导出sas7bdata至excel

大风大浪就是闯

1. /*创建输出excel的宏*/
   
2. %macro export(inlib,intbl,outpath,outfile);
   
3.   proc export data=&inlib..&intbl  
   
4.     outfile= "&outpath\&outfile..xls"     
   
5.     dbms=xls label replace;
   
6.     putnames=yes;
   
7.   run;
   
8. %mend;
   
9. 
   
10. %let outpath=F:\excel_files; /*输出excel路径*/
    
11. %let inpath=F:\sas7bdata_files;/*sas数据所在路径*/
    
12. libname source "&inpath";/*创建逻辑库source*/
    
13. data _null_;
    
14.   set sashelp.vstable (where=(libname='SOURCE'));
    
15.   call execute(cats('%nrstr(%export)('
    
16.                    ,catx(',',libname,memname,'&outpath',memname)
    
17.                    ,')'));
    
18. run;

复制代码