topic Re: ODS RTF and PROC REPORT in ODS and Base Reporting

ODS RTF and PROC REPORT

deleted_user — Tue, 23 Oct 2007 17:52:08 GMT

I am not sure if this topic has already been discussed, but I am trying to produce an RTF using ODS and PROC REPORT and I am having some problems getting the output to look like I need it to.

Specifically, I want to have a bold line between the title and the row headers, as well as between the table and the footnotes. I tried using RULES=GROUPS, however, this does not give me what I need if the table spans more than 1 page. Only the last page will display a line before the footnote.

Also, I need the footnotes to appear on every page, and since I am using BODYTITLE, it only appears on the last page.

Any suggestions on how to get around these issues?

Thanks in advance!!

Re: ODS RTF and PROC REPORT

Cynthia_sas — Tue, 23 Oct 2007 18:37:47 GMT

Hi:
BODYTITLE is working as designed. You can either get the title and footnotes in the header and footer area of the word processor OR you get the TITLE at the top of the table (generally on page 1) and the FOOTNOTE at the end of the table (on page ???) -- by using BODYTITLE.

This may change for SAS 9.2, but for now, this is the way that BODYTITLE works.

So you may have to work with Tech Support to decide whether you want BODYTITLE or not. You can put lines into your RTF file by using RTF control strings as shown in the code at these postings (using BRDRT control string).
http://support.sas.com/forums/thread.jspa?messageID=2830଎
http://support.sas.com/forums/thread.jspa?messageID=2531ৣ

Another thought is to try the JOURNAL style and see if you like the way that the output looks. When questions like this come up in class, I find that JOURNAL comes closest to the look that most of my students want when they describe this kind of report.

cynthia

Re: ODS RTF and PROC REPORT

deleted_user — Tue, 23 Oct 2007 18:48:24 GMT

Cynthia,
Thanks for your response! I just tried journal, and it does look very close to what I need. Is there any way to make the "RULES" lines that appear before and after the table thicker, or at least in bold?

Thanks again!

Re: ODS RTF and PROC REPORT

Cynthia_sas — Tue, 23 Oct 2007 19:21:34 GMT

Hi, Phil:
You could experiment with Borderwidth -- which in my Word works for the top and bottom lines:
[pre]
ods rtf file='c:\temp\tryjour.rtf' style=journal;
proc report data=sashelp.class nowd
style(report)={borderwidth=10};
run;
ods _all_ close;
[/pre]

I show it here with a STYLE= statement level override. I think 10 is a bit too big and too bold, but you get the idea.

cynthia

Re: ODS RTF and PROC REPORT

deleted_user — Tue, 23 Oct 2007 19:24:58 GMT

Cynthia,
Thank you so much!!! BORDERWIDTH is exactly what I needed, and it worked beautifully. Thanks again for all of your help!

-Phil