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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.