SAS EXCEL 自动生成目录代码

OPTIONS NOCENTER USER=. LS=MAX PS=MAX ERROR=1;

%PUT SAS VERSION = &SYSVLONG;


ODS EXCEL FILE='ODS.EXCEL.TEST01A_5.XLSX'
    OPTIONS(EMBEDDED_TITLES="YES" CONTENTS="YES"
    SHEET_INTERVAL="TABLE"
);


DATA A;
    A1='The Table of Contents';
    OUTPUT;
RUN;

PROC REPORT DATA=A nowd;
 columns A1;
compute A1;
 call define(_col_,'url',"#'The Table of Contents'!A2");
 call define(_col_,'style','style={textdecoration=underline color=blue}');
endcomp;
RUN;



ODS EXCEL CLOSE;