sas数据集或报表输出excel

 ODS tagsets.excelxp FILE='..\03@REPORT\about_sheet.xls';


 ODS tagsets.excelxp options(Sheet_NAME="abc"  sheet_interval='NONE'  );
 PROC TABULATE DATA=S.MANYSFJJZ_FINAL; 
CLASS ZXPF SJPF ZXPFFZ SJPFFZ;
TITLE1 '该分组内男性申请量';
VAR SOMENUM;
table  (ZXPF=''*ZXPFFZ=''),(SJPF=''*SJPFFZ=''*SUM=''*(SOMENUM=''*f=8.)) /style=[borderwidth=1]  ;
LABEL SOMENUM='申请量'; 
RUN;


 PROC TABULATE DATA=S.MANYSFJJZ_FINAL; 
CLASS ZXPF SJPF ZXPFFZ SJPFFZ;
TITLE1 '该分组内男性申请量占比';
VAR BFB SOMENUM;
table  (ZXPF=''*ZXPFFZ=''),(SJPF=''*SJPFFZ=''*SUM=''*(BFB=''*f=PCTFML.)) / style=[borderwidth=1]  ;
LABEL BFB='申请量占比'; 
RUN;  


ODS tagsets.excelxp options(Sheet_NAME="def" sheet_interval='none');
PROC TABULATE DATA= S.MANZSFJJZ_FINAL; 
CLASS ZXPF SJPF ZXPFFZ SJPFFZ / MISSING;
TITLE1 "终审该分组内男性通过人数";
VAR TGNUM;
table  (ZXPF=''*ZXPFFZ=''),(SJPF=''*SJPFFZ=''*TGNUM=''*f=8.) / style=[borderwidth=1] ;
 
RUN;


PROC TABULATE DATA= S.MANZSFJJZ_FINAL; 
CLASS ZXPF SJPF ZXPFFZ SJPFFZ / MISSING;
TITLE1 '最终该分组内男性通过率';
VAR BFB;
table  (ZXPF=''*ZXPFFZ=''),(SJPF=''*SJPFFZ=''*BFB=''*f=PCTFML.) /style=[borderwidth=1] ;
RUN;




ODS tagsets.excelxp CLOSE;