Not certain what you want to see...here is a code sample that worked previously but no longer does:
ODS TAGSETS.EXCELXP FILE=OUTXLS STYLE=STYLES.XLStatistical
TRANTAB=ASCII;
%LET L = 1;
%DO %UNTIL (%QSCAN(&EVTLST,&L)=);
%LET EVT = %UNQUOTE(%QSCAN(&EVTLST,&L));
ODS TAGSETS.EXCELXP
OPTIONS (SHEET_NAME="&EVT &RPTST RESIDENTS"
FROZEN_HEADERS='1' ROW_REPEAT='1'
CENTER_HORIZONTAL='Yes'
ABSOLUTE_COLUMN_WIDTH='6,16,7,16,20,9,5');
TITLE1 "&&ENAME&EVT &&PROC&BATCH";
PROC PRINT DATA=ALLEVT NOOBS LABEL SPLIT='/';
WHERE FSTATRES = "US&RPTST" AND EVENT = "&EVT";
VAR YEAR / style=data_c;
VAR FSTATOCC;
VAR FILENO / style=data_c{tagattr="format:000000"};
VAR FSTATRES FCNTYRES;
VAR DATE / style=data_c;
RUN;
%LET L = %EVAL(&L + 1);
%END;
ODS TAGSETS.EXCELXP CLOSE;
... View more
