topic Re: Suppressing TABULATE row titles in RTF in ODS and Base Reporting

Suppressing TABULATE row titles in RTF

deleted_user — Mon, 05 Jan 2009 17:26:51 GMT

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,

Re: Suppressing TABULATE row titles in RTF

David_SAS — Mon, 05 Jan 2009 18:15:08 GMT

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

Re: Suppressing TABULATE row titles in RTF

deleted_user — Mon, 05 Jan 2009 20:25:23 GMT

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

Re: Suppressing TABULATE row titles in RTF

David_SAS — Mon, 05 Jan 2009 21:27:54 GMT

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

Re: Suppressing TABULATE row titles in RTF

deleted_user — Tue, 06 Jan 2009 00:08:50 GMT

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

Re: Suppressing TABULATE row titles in RTF

David_SAS — Tue, 06 Jan 2009 14:54:41 GMT

John,

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

-- David Kelley, SAS

Re: Suppressing TABULATE row titles in RTF

deleted_user — Tue, 06 Jan 2009 17:04:27 GMT

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

Re: Suppressing TABULATE row titles in RTF

Duong — Thu, 08 Jan 2009 18:05:53 GMT

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