Table of content based on the ods output

[SU22]

Hi,

I have a SAS program that outputs an excel file with different tabs (eg 10 tabs). On the same Excel file, I want to create another tab right before all those 10 tabs to use as a table of contents. On that sheet, I want to grab A2 of all those tabs and list them in each row on the new sheet that I want to use as table of content.

What do you recommend?

Thanks,

[JosvanderVelden]

Have you seen this blogpost: https://blogs.sas.com/content/sgf/2017/02/20/tips-for-using-the-ods-excel-destination/ . See the section "Navigating a Microsoft Excel Workbook".

Best regards, Jos

[Tom]

There is on option to turn on the generation of a table of contents.

ods excel file='c:\downloads\contents.xlsx' options(contents='on');
proc print data=sashelp.class; run;
proc means data=sashelp.class; run;
ods excel close;