I cannot get the compute block to change the background color of the SUM of the METRIX variable. I have created a temp variable t_METRIX that equals the METRIX sum/mean to give me a percentage that should change the background color in the compute block. Unfortunately it is not working so I know that I must be doing something wrong. Any help would be appreciated. proc format; value cback 0 - .00 = 'lightyellow' 1 - 100000 = 'white'; VALUE ratio 0 - 0.20 = 'red' 1.20 - HIGH = 'green'; run; PROC REPORT DATA=ETLFW.ALL_TABLES_DAILY_LOAD_STATUS NOWD; TITLE "Summary Tables for ETLFW.SCORECARD_TABLES_LOAD_STATUS"; COLUMN SOURCE_SYSTEM_NAME SCHEMA_NM TABLE_NM LOG_DT,(METRIC,(SUM)) METRIC,(MEAN); DEFINE SOURCE_SYSTEM_NAME / GROUP; DEFINE SCHEMA_NM / GROUP; DEFINE TABLE_NM / GROUP; DEFINE LOG_DT / ACROSS; DEFINE METRIC / ANALYSIS SUM MEAN; DEFINE SUM / format=comma6. style(COLUMN)={background=cback.} 'Row count'; DEFINE MEAN / 'Average Row count' format=comma6.; compute METRIC; t_METRIC = SUM / MEAN; if t_METRIC > 0.20 and t_METRIC < 1 then call define(_col_,'style','style=[background=lightred]'); else if t_METRIC > 1.20 and t_METRIC < 1 then call define(_col_,'style','style=[background=lightgreen]'); endcomp; ; run;
... View more