topic Re: Table of content based on the ods output in ODS and Base Reporting

Table of content based on the ods output

SU22 — Fri, 20 May 2022 00:57:52 GMT

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,

Re: Table of content based on the ods output

JosvanderVelden — Fri, 20 May 2022 10:10:08 GMT

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

Re: Table of content based on the ods output

Tom — Fri, 20 May 2022 13:42:52 GMT

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;