How do I apply conditional formatting in Proc Report, to an "analysis" variable?

[MART1]

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

[PaigeMiller]

Lots of examples here:

https://www.lexjansen.com/wuss/2006/tutorials/TUT-Carpenter.pdf

[MART1]

thanks PaigeMiller

I didn't come across this article when I was looking

thanks

[ballardw · Accepted solution]

I suspect that you may have used the wrong value for your format. It may help to show what you tried that "didn't work" as we can explain why not. For example the actual value of 3% is 0.03. So that would be the value to use in a format range.

Proc format library=work;
value threepct
.03 - high ='red'
other
;


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 style=[background=threepct.];
     define region / group 'region' missing;

quit;

[MART1]

that's great many thanks ballardw

I was not applying the "style" syntax correctly

thanks