PROC ODS - Highlighting a cell

[DLROW]

Hi - I need to highlight a variance (cell)  that is >=15% or <=-15%. Below is the sample and code. Please help. Thanks.

ODS EXCEL;

PROC REPORT Data=DATA1

COLUMNS First Group Second Group Date_MMYYYY, TOTAL_COUNT Date_MMYYYY,VARIANCE;
define FIRST GROUP / group 'First group' ORDER = INTERNAL;
define SECOND GROUP / group 'Second Group' ORDER = INTERNAL;
define DATE_MMYY / across '';
define TOTAL_COUNT / analysis '' format=comma20.;
define VARIANCE / analysis '' format=percent8.2;

Run;
title;

ods excel close;

[Reeza]

You can try a COMPUTE block like this one:

https://stackoverflow.com/questions/14389941/sas-conditional-row-highlighting-with-ods-and-proc-prin...

Or you can try custom formats, this paper does a great job explaining all the different implementation options. 

https://www.lexjansen.com/wuss/2006/tutorials/TUT-Carpenter.pdf

---

@DLROW wrote:

Hi - I need to highlight a variance (cell)  that is >=15% or <=-15%. Below is the sample and code. Please help. Thanks.

ODS EXCEL;

PROC REPORT Data=DATA1

COLUMNS First Group Second Group Date_MMYYYY, TOTAL_COUNT Date_MMYYYY,VARIANCE;
define FIRST GROUP / group 'First group' ORDER = INTERNAL;
define SECOND GROUP / group 'Second Group' ORDER = INTERNAL;
define DATE_MMYY / across '';
define TOTAL_COUNT / analysis '' format=comma20.;
define VARIANCE / analysis '' format=percent8.2;

Run;
title;

ods excel close;

---

[Cynthia_sas]

Hi:
In addition to @Reeza's suggestions, this paper goes into more detail:
https://support.sas.com/resources/papers/proceedings14/SAS388-2014.pdf about working with ACROSS items.
Cynthia

[DLROW]

Thanks all. I went through those papers and I got what I need.