topic Re: Highlighting and multi-sheet in SAS Programming

Highlighting and multi-sheet

chprby12 — Sat, 16 Sep 2017 12:01:45 GMT

Can you show example code to add detail sheets to an ODS HTML sheet with highlighted rows and cells?

Re: Highlighting and multi-sheet

Cynthia_sas — Sat, 16 Sep 2017 13:20:31 GMT

Hi:
I am not sure what you mean by "detail sheets" when you make an ODS HTML file, even from multiple SAS outputs, the HTML file is 1 HTML page. If you open the HTML file in Word, then it is 1 Word doc; if you open the HTML file with Excel then it is 1 Excel worksheet in 1 workbook. So there is not a concept of "multi-sheet" with ODS HTML. If you plan to open the SAS output file with Excel, you might be better served by looking at other destinations.

On the other hand, if you switch to ODS TAGSETS.EXCELXP or ODS EXCEL, then you can easily get multi-sheet workbooks.

Regarding your question about highlighted rows and cells -- the method you use for highlighting will depend on your procedure of choice. This paper outlines methods of highlighting in PROC PRINT, PROC REPORT and PROC TABULATE:
http://support.sas.com/resources/papers/proceedings13/366-2013.pdf
cynthia

Re: Highlighting and multi-sheet

Reeza — Sat, 16 Sep 2017 18:01:26 GMT

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

Re: Highlighting and multi-sheet

chprby12 — Wed, 11 Oct 2017 09:24:20 GMT

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!

Re: Highlighting and multi-sheet

Reeza — Wed, 11 Oct 2017 14:55:44 GMT

@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.