I would like to make the data columns gray for all rows with 'Total' in the subdiv field. I am able to change the 'Total' cell, but need the entire row to be gray. Any suggestions? I've searched here but haven't found anything that works. Thank you!!!!
proc format; value $subb 'Total'='gray'; value $subf 'Total'='white'; run;
title;
title1 "Sales Incentive and Rate Promotion Report"; title2 "&month &year"; footnote; footnote1 j=center "Central Information Group (CIG) -- MRIT #163"; footnote2 j=center "Confidential"; footnote3 j=center "Posted to: COE Reporting Site -- Last Updated: &today";
proc tabulate data=totals_2(firstobs=1) out=report_sum_table(label="") format=comma20.2; var jan feb mar apr may jun jul aug sep oct nov dec ytd_region_total; class marketareaname / order=data missing; class report_order / order=formatted missing ; class subdiv / order=formatted missing; classlev subdiv / style={background=$subb. foreground=$subf.}; class group / style={foreground=white background=gray} order=data missing; class region1 / order=data missing; table /* Page Dimension */ marketareaname={label=" "}, /* Row Dimension */ group={label=" "} * subdiv={label=" "} * region1={label=" "}, /* Column Dimension */ jan* sum={label=""} feb* sum={label=""} mar* sum={label=""} apr* sum={label=""} may* sum={label=""} jun* sum={label=""} jul* sum={label=""} aug* sum={label=""} sep* sum={label=""} oct* sum={label=""} nov* sum={label=""} dec* sum={label=""} ytd_region_total* sum={label=""} /*Table Options */ / box={label=_page_} indent=0;; run;run;quit; title; footnote;
... View more