topic Re: How do I apply conditional formatting in Proc Report, to an "analysis" variable? in New SAS User

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

MART1 — Tue, 07 Apr 2020 16:13:39 GMT

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

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

PaigeMiller — Tue, 07 Apr 2020 17:08:04 GMT

Lots of examples here:

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

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

ballardw — Tue, 07 Apr 2020 17:06:01 GMT

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;

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

MART1 — Fri, 10 Apr 2020 16:28:41 GMT

that's great many thanks ballardw

I was not applying the "style" syntax correctly

thanks

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

MART1 — Fri, 10 Apr 2020 16:30:02 GMT

thanks PaigeMiller

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

thanks