My apologies. Please see below. I have simplified the code by removing all of of the styles. My main goal is to create a conditional format on columns, al, no, geo, and ms. The table is currently set up to show a district percent and national percent by grade (please see attached picture in the original question). If the district percent is greater than the national percent, then I want to have that percent be bold. I could use proc format and create a long list of formats, but I was trying to find a quicker way around. Does that make more sense?
proc report data=math_domain_prof nowd spanrows
style(report)=[cellspacing=0pt cellpadding=0pt fontsize=11pt bordercolor=CX4BACC6];
where grade in (0:8);
column student_Grade_level_id D_N al geo ms no;
define student_Grade_level_id/ order order=DATA flow 'Grade';
define D_N / 'District/National' group order=DATA flow;
define al /'Algebra and Algebraic Thinking' flow;
define no/ 'Numbers and Operations' flow;
define geo/ 'Geometry' flow;
define ms / 'Measurement and Data' flow;
compute after student_Grade_level_id / style={borderbottomwidth=3pt};
endcomp;
run;
... View more
