I want my report to color the cells red in the field named pct_ind5a that are less than 56. My code below colors the entire column. I also get a message that pct_ind5a is uninitialized. Yet, the variable is in the data set and it shows on the report.
proc report data=join1a nowd split='*' style(header)={background=cx66cc99 font_size=10pt} style(column)={font_size=10pt} style(report)={vjust=c just=c cellpadding=0pt} style(column)={just=center}; column ("" school) (" " pct_ind5a) (" " pct_ind5b); define school/ style=[width=200]; define pct_ind5a/ style=[width=80]; define pct_ind5b/style=[width=80]; compute school; endcomp; compute pct_ind5a; if pct_ind5a < 56 then call define (_COL_,'style','style={background=red}'); endcomp; compute pct_ind5b; endcomp; title "School Profile Reports 2014-2015";
... View more
