home sheet or table of contents in proc report ods excel

[snip]

Good Morning

I have an old Excel report that I need to reproduce under SAS for automation purposes. I used the class table in the example for demonstration, knowing that the class table does not represent my real data.

I'm trying to build a sort of table of contents (home sheet) like the example.

I click on Age 11 ==> Age 11 tab opens...

Is it possible to do something that is close to the example? with the possibility of formatting.... 

proc sort data=sashelp.class out=class ;by age; run;
ods excel file='C:\temp\class.xlsx'
options(embedded_titles='yes' FROZEN_ROWHEADERS='3' frozen_headers='yes' tab_color='red' start_at='A4'
embedded_footnotes='yes' sheet_name = "#byval1"  contents="yes");

PROC REPORT data=class; 
by age;
column   age sex name;
define age/group;
define sex /display;
define name /display;
run;
ods excel close;

[Cynthia_sas]

Hi: I do not think you can control the formatting using either INDEX="ON" or CONTENTS="YES". I am fairly sure there's not a good way to add big buttons, such as you show in your screen shot. However, you might want to check with Tech Support for the definitive answer.
Cynthia

[snip · Accepted solution]

ok thank you

[Kurt_Bremser]

PROC REPORT within ODS HTML and a BY statement can create a frameset with a navigation sub-page.