Suppressing TABULATE row titles in RTF

[deleted_user]

Hi folks,

Once can use varname=''' in the TABLES statement of Proc Tabulate to suppress the printing or row titles, which is what I want. However, when I use this with ODS RTF (SAS 8.2), I end up with a rather messy (blank) 'residue' of the row title, which currently I'm having to remove 'manually' from the rtf output.

Is there a way, perhaps with a suitable ODS RTF Style, to avoid this problem?

TIA for any help.

Kind Regards,

[David_SAS]

John,

For SAS 8.2, try the workaround of INDENT=0 on the TABLE statement.

More recent versions of SAS support the traditional ROW=FLOAT TABLE statement option.

-- David Kelley, SAS

[deleted_user]

David,

> For SAS 8.2, try the workaround of INDENT=0 on the
> TABLE statement.

Very many thanks. That achieves exactly what I wanted (in the RTF output). However, I wonder why it works? I think I could have read the documentation for INDENT= a million times and still not have suspected that it represented a solution to my problem. Is it just a fluke that it achieves what I want, or is it in some sense 'to be expected' from the functionality of the option? Interestingly, what it does to the Listing output of TABULATE is definitely not what I wanted, even though it does the right thing to the RTF!

Thanks Again,

Kind Regards
John

[David_SAS]

John,

By the time development was wrapping up for SAS 8.2, I had not implemented support for ROW=FLOAT. I provided INDENT=0 as a workaround. It doesn't make much sense to say INDENT=0, but I didn't obsess about that because I knew ROW=FLOAT, the proper solution, would be available in SAS 9.0.

-- David Kelley, SAS

[deleted_user]

David,

> By the time development was wrapping up for SAS
> 8.2, I had not implemented support for ROW=FLOAT. I
> provided INDENT=0 as a workaround. It doesn't make
> much sense to say INDENT=0, but I didn't obsess
> about that because I knew ROW=FLOAT, the proper
> solution, would be available in SAS 9.0.

That's a very good explanation which falls well on my pragmatist ears! I take it you mean that you had not implemented the support for ROW=FLOAT in relation to the rtf output - since it is available (and documented) in SAS 8.2, but does not seem to have any effect on the rtf issue I'm discussing (i.e. it does not have the same effect as INDENT=0). Is that correct?

Kind Regards,
John

[David_SAS]

John,

That is correct. ROW=FLOAT works only for the Listing (default) destination in SAS 8.2.

-- David Kelley, SAS

[deleted_user]

David,

> That is correct. ROW=FLOAT works only for the
> Listing (default) destination in SAS 8.2.

Thanks for confirming. I'm just grateful that you were thoughtful enough to include the INDENT=0 workaround, in the absence of ROW=FLOAT working with the RTF destination! Many thanks.

Kind Regards,
John

[Duong]

Hi John

I think this would also work. I used this quite often in Proc Report
but I have not tried it out in Proc Tabulate.

varname = "{}"

Regards
Duong