Hello
I need to apply different colours to the background of a variable, based on the value, in a Proc Report.
I have recreated an example using sashelp:
proc report data=sashelp.demographics nowd;
column region (name, (Pop PopAGR));
define name / across 'name' ORDER=DATA;
define Pop / analysis SUM 'Pop' missing;
define PopAGR / analysis SUM 'PopAGR' missing;
define region / group 'region' missing;
quit;
I need to, say, highlight "PopAGR" in red if it's > 3.00%
I know "if call define" does not work as I am using the variable as "analysis".
I've also tried Proc Format, but I cannot make it work.
I've looked everywhere but can't find a solution!
Thanks in advance
I am using EG 7.13