Hello,
I have a question about new SAS 9.4 m2 feature ODS EXCEL. Probably it is a silly quesiton, I'm a beginner with ods.
I'm trying to use the 'index=' suboption wich creates a worksheet that contains an index of all worksheets appearing in the excel report.
ODS excel file="/home/excel_REPORT.xlsx" options( dpi='300'
embedded_titles='on'
embedded_footnotes='yes'
sheet_interval="page"
index='on')
well, what I woud like to do is to add some enanchements to the index worksheet generated. For istance I would like to insert a title or change font settings for index items.
Thanks.
Thanks for the answer.
What I actually see is that no Excel style template (wich is the default template for ODS excel ) is in my sas release (SAS 9.4 m2). If i run the following code:
proc template;
source styles.excel;
run;
Here is the log:
9304 proc template;
9305 source styles.excel;
WARNING: Path 'Styles.Excel' does not exist!
9306 run;
As long as the Excel style should be in the inheritance for any applied style, it is impossible for me to modify it and apply a custom one. It sounds a bit wierd.
The default style for ODS EXCEL in 9.4M2 is HTMLBlue.
I'll try to create a new custmized style template starting from HTMLBlue. Thanks.
I retrived that info, about defult excel style, from the paper attached (page2).
That tip sheet is accurate for ODS EXCEL in SAS 9.4M3, but not for 9.4M2.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.