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;
ok thank you
ok thank you
PROC REPORT within ODS HTML and a BY statement can create a frameset with a navigation sub-page.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.