So I finally got a chance to draw up some examples here. It's not that I want to get tagattr on the class, it's that to get it on the data, I need to tag not the statistics, but the class lines. First example here will show that. ods _all_ close; ods tagsets.excelxp file='c:\something2.xml' style=normal; *Nothing Highlights because 2nd Tag overrides; proc tabulate data=sashelp.shoes missing; where region in ("Africa",'Asia'); class region product; var sales; table (region='' all) * (product='' all='Total NCO'*{s={font_weight=bold background=lightblue tagattr='$#,##0.0,,;[Red]($#,##0.0,,);"-"' just=center}}), (sales='Sales' *sum=''*{s={font_weight=bold tagattr='$#,##0.0,,;[Red]($#,##0.0,,);"-"' just=center}}) /box = 'Style Override 1'; /*keyword all / style={background=lightblue};*/ run; *Data highlights, not the row headers (I like this one most); proc tabulate data=sashelp.shoes missing; where region in ("Africa",'Asia'); class region product; var sales; table (region='' all) * (product=''*{s={font_weight=bold tagattr='$#,##0.0,,;[Red]($#,##0.0,,);"-"' just=center}} all='Total NCO'*{s={font_weight=bold background=lightblue tagattr='$#,##0.0,,;[Red]($#,##0.0,,);"-"' just=center}}), (sales='Sales' *sum='') /box = 'Style Override 2'; /*keyword all / style={background=lightblue};*/ run; *Row Headers highlight with data, but also highlights Region\all; proc tabulate data=sashelp.shoes missing; where region in ("Africa",'Asia'); class region product; var sales; table (region='' all) * (product=''*{s={font_weight=bold tagattr='$#,##0.0,,;[Red]($#,##0.0,,);"-"' just=center}} all='Total NCO'*{s={font_weight=bold background=lightblue tagattr='$#,##0.0,,;[Red]($#,##0.0,,);"-"' just=center}}), (sales='Sales' *sum='') /box = 'Style Override 3'; keyword all / style={background=lightblue}; run; ods tagsets.excelxp close;
... View more
