There's not actually an option for me to attach a file. So the "no style" output below has columns first\second\third. The header background is beige and the data background is white. In the second, styled output, the column third is all green, but the first\second columns' data background also carries the header background - they fill beige instead of remaining white. ods tagsets.excelxp file= "test.xml" style=normal options (SHEET_INTERVAL="none"); title 'no styles'; proc tabulate data = test; class name category; var val; table name=' ',category=' '*val=' '; keylabel sum=' '; run; proc format; value $cat /*'first'=yellow*/ /*'second'=red*/ 'third'=green; run; title 'Green is styled intentionally, but first\second are unintentionally'; proc tabulate data=test; class name category; classlev category / s=[background=$cat.]; var val / style=<parent>; keyword sum / style=<parent>; keylabel sum=' '; table name=' ',category=' '*val=' '* {style=<parent> {foreground=black}}; run; ods tagsets.excelxp close;
... View more
