topic Applying a STYLE on an entire column and row simultaneously in ODS and Base Reporting

Applying a STYLE on an entire column and row simultaneously

deleted_user — Sat, 02 Aug 2008 03:16:55 GMT

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.

Re: Applying a STYLE on an entire column and row simultaneously

Cynthia_sas — Sat, 02 Aug 2008 03:30:19 GMT

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