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;
... View more