topic Re: PROC ODS - Highlighting a cell in ODS and Base Reporting

PROC ODS - Highlighting a cell

DLROW — Thu, 01 Oct 2020 02:57:28 GMT

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;

Re: PROC ODS - Highlighting a cell

Reeza — Thu, 01 Oct 2020 03:06:43 GMT

You can try a COMPUTE block like this one:

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

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;

Re: PROC ODS - Highlighting a cell

Cynthia_sas — Thu, 01 Oct 2020 14:12:57 GMT

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

Re: PROC ODS - Highlighting a cell

DLROW — Thu, 01 Oct 2020 18:51:04 GMT

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