topic Re: Highlight cells in a SAS dataset so that it is highlighted when exported to Excel in SAS Procedures

Highlight cells in a SAS dataset so that it is highlighted when exported to Excel

mzhao2 — Thu, 21 May 2020 20:53:32 GMT

Hi SAS communities,

I currently have a script that exports SAS datasets to Excel using proc export. However, I need to highlight the maximum absolute values for some variables and this formatting needs to be there when the dataset is exported to an Excel file. I was wondering what is the best way to approach this?

Thanks!

Re: Highlight cells in a SAS dataset so that it is highlighted when exported to Excel

Reeza — Thu, 21 May 2020 21:13:49 GMT

ODS EXCEL + PROC REPORT for traffic lighting.

This paper covers it in detail, and has a specific traffic lighting example starting on page 7.

https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2018/2765-2018.pdf