The SAS Output Delivery System and reporting techniques

Applying a STYLE on an entire column and row simultaneously

Reply
N/A
Posts: 0

Applying a STYLE on an entire column and row simultaneously

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.
SAS Super FREQ
Posts: 8,868

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

Posted in reply to deleted_user
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
Ask a Question
Discussion stats
  • 1 reply
  • 118 views
  • 0 likes
  • 2 in conversation