Applying a STYLE on an entire column and row simultaneously

[deleted_user]

Good Day!
I have generated a HTML table using PROC TABULATE and exported it to EXCEL using an ODS tagset table editor.I applied a foreground and background across a specific column using the "" statement, however it overwrites the style of the "ALL" row.

Is there any way to use the statement on columns and rows simultaneously such that it will not overwrite each others properties.

[Cynthia_sas]

Hi:
If this were Proc Report in SAS 9.2, you might use the new STYLE/MERGE in a CALL DEFINE statement, but alas, TABULATE does not have that capability. The only thing you can do with TABULATE is tell it which dimension "wins" in the case of a collision between a row style specification and a column style specification:
[pre]
table page-dim,
row-dim,
col-dim / style_precedence=????? ;
[/pre]

Where you plug PAGE or ROW or COL where I have the ?????

cynthia