topic home sheet or table of contents in proc report ods excel in SAS Programming

home sheet or table of contents in proc report ods excel

snip — Fri, 20 Oct 2023 13:24:29 GMT

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;

Re: home sheet or table of contents in proc report ods excel

Cynthia_sas — Fri, 20 Oct 2023 15:56:10 GMT

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

Re: home sheet or table of contents in proc report ods excel

snip — Tue, 24 Oct 2023 09:45:34 GMT

ok thank you

Re: home sheet or table of contents in proc report ods excel

Kurt_Bremser — Tue, 24 Oct 2023 10:03:53 GMT

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