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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.