Hi,
I have a SAS program that outputs an excel file with different tabs (eg 10 tabs). On the same Excel file, I want to create another tab right before all those 10 tabs to use as a table of contents. On that sheet, I want to grab A2 of all those tabs and list them in each row on the new sheet that I want to use as table of content.
What do you recommend?
Thanks,
There is on option to turn on the generation of a table of contents.
ods excel file='c:\downloads\contents.xlsx' options(contents='on');
proc print data=sashelp.class; run;
proc means data=sashelp.class; run;
ods excel close;
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.