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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: