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?
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.
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.
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?
You could experiment with Borderwidth -- which in my Word works for the top and bottom lines:
ods rtf file='c:\temp\tryjour.rtf' style=journal;
proc report data=sashelp.class nowd
ods _all_ close;
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.