下面这个程序实现从SAS到EXCEL,但是风格很难看,有无更好的风格展现?
ods listing close;
ods tagsets.ExcelXP path='d:\' file='aedata.xls' style=SUGI31;
ods tagsets.ExcelXP options(sheet_interval='none' sheet_name='Data - test 1');
PROC TABULATE DATA=SASHELP.CLASS;
VAR WEIGHT;
CLASS SEX AGE;
TABLE SEX*AGE,WEIGHT*SUM='';
RUN;
ods tagsets.ExcelXP options(sheet_interval='none' sheet_name='Data - Test 2');
proc print data=sashelp.class;
var name sex weight;
run;
ods tagsets.ExcelXP close;
ods listing;