Can you show example code to add detail sheets to an ODS HTML sheet with highlighted rows and cells?
Hi,
I found out I can perform highlighting and also have multiple sheets in one workbook. I just have to revert to outputting to older Excel version, saving to an .xls file.
Thanks!
@chprby12 wrote:
Hi,
I found out I can perform highlighting and also have multiple sheets in one workbook. I just have to revert to outputting to older Excel version, saving to an .xls file.
Thanks!
It depends on your version of SAS. If you have 9.4+ you can use ODS EXCEL and get a native XLSX file.
ODS HTML will produce an HTML file, even if you label it xls. Excel will open it (most of the time) but you will have a warning pop up.
HTML doesn't have the concept of pages or sheets. It's a continuous document, but you can link to other HTML pages or within the same document if you really wanted.
If you search on LexJansen.com you'll fin a ton of examples and papers people have written on this topic.
http://www2.sas.com/proceedings/sugi28/023-28.pdf
https://www.mwsug.org/proceedings/2014/SA/MWSUG-2014-SA13.pdf
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.