proc report conditionally formatting summarize results

sebster24 — Fri, 30 Aug 2019 16:14:11 GMT

Hello, I am currently presenting some results in proc report and intend to apply some conditional formatting to a summarize result.

I am using proc report for its ease in exporting the figures to latex.

I have written below the following code::



proc report data= SASHELP.SHOES
style(header)=[color=black  fontfamily=helvetica fontsize=1 background=yellow fontweight=bold];
column region Stores;
define region / "region" display style(column)=[width=2cm] group;
define stores/"stores" display style(column)=[width=3.5cm] mean; 
rbreak after/ summarize style=Header;
compute after;
region="Mean";
endcomp;

compute stores;
if _break_="_RBREAK_" then do;
	if stores >= 5 then call define('stores.mean','style','style={backgroundcolor=green}');
	else if stores < 5 then call define('stores.mean','style','style={backgroundcolor=yellow}');
	else if stores < 2 then call define('stores.mean','style','style={backgroundcolor=red}');
end;
endcomp;
run;

My issue is the output (mean) of stores (mean=11.648) should have a background colour "green", given the "if" condition. I am unable to figure out why it is "Yellow".

Thanks.

Re: proc report conditionally formatting summarize results

JosvanderVelden — Fri, 30 Aug 2019 17:21:49 GMT

If you have not found the error yourself yet use:
if stores.mean ...
else if stores.mean ...
else if stores.mean ...

topic proc report conditionally formatting summarize results in SAS Procedures

proc report conditionally formatting summarize results

Re: proc report conditionally formatting summarize results