使用SAS存储过程直接输出excel文件最简单的方法

大家借鉴借鉴 

 

data _null_;
rc = stpsrv_header('Content-type',"application/vnd.ms-excel");
rc = stpsrv_header('Content-disposition',"attachment; filename=file.csv");
run;

%let _odsdest = tagsets.csv;
%let _odsstyle = sasweb;

%stpbegin;

ods CSV  body=_webout options (doc='help' delimiter=';');

proc PRINT data=sashelp.class;
run;

ods CSV close;

%stpend;