Hi: Just for comparison purposes, here's the solution for trafficlighting your WORK.TEST data, directly from PROC REPORT, without creating an output dataset first and, without using CNTLIN. You are correct that the REPORT syntax is different, but you can ask for the MEAN statistic directly, using VARA and VARB as GROUP report items. If you wanted the entire ROW to be red, including VARA and VARB, then the first argument to the CALL DEFINE statement could change to _ROW_. But I thought it looked better with VARA and VARB using Header style -- so I just highlighted VAR1-VAR4 separately in the COMPUTE block. cynthia data test; input vara $ varb $ var1 var2 var3 var4; return; datalines; a a 1 2 3 0.01 a b 4 5 6 0.02 a a 7 8 9 0.03 a b 10 11 12 0.04 b a 13 14 15 0.05 b b 16 17 18 0.06 b a 19 20 21 0.07 b b 22 23 24 0.08 ; run; ods html file='c:\temp\rephilite.html' style=egdefault; ** proc report alternative; ** data does not need to be pre-summarized tabulate first; proc report data=test nowd; column vara varb var1 var2 var3 var4; define vara / group style(column)=Header; define varb / group style(column)=Header; define var1 / mean f=6.2; define var2 / mean f=6.2; define var3 / mean f=6.2; define var4 / mean f=6.2; compute var4; if var4.mean le 0.05 and var4.mean ne . then do; call define('var1.mean','style','style={color=red}'); call define('var2.mean','style','style={color=red}'); call define('var3.mean','style','style={color=red}'); call define('var4.mean','style','style={color=red}'); end; endcomp; run; ods html close;
... View more