Dear all. I have a problem with the conversion of SAS RTF output to Word. I'm using SAS 9.3 with an RTF ODS output (via styles and proc template) to create statistical summary tables. Many times when I open the resulting RTFs in Word I find that Word seems to think that it can only fit a limited amount of rows on one page (leaving a lot of whitespace at the bottom of each page). It can be especially large when I use a footnote. It looks horrible and increases the size of the documents considerably. I would like to produce more optimal page layout with the number of rows per page closer to what can be fit. Does anybody know why this happens and whether you can force Word to display a larger number of rows on a page. For columns you can simply use the CELLWIDTH option, but I haven't found anything that controls the rows. I run my reports per page (BY pagord). Below is an example of my proc template and structure of the proc report. In the styles we only specify things like margins, font sizes, etc. Many thanks in advance! Kind regards, Just PROC TEMPLATE; DEFINE STYLE styles.xxx; PARENT=styles.printer; STYLE Fonts from Fonts / 'TitleFont' = ("Times New Roman",8pt,Bold Italic) 'headingFont' = ("Times New Roman",8pt,Bold) 'footFont' = ("Times New Roman",8pt,Bold Italic) 'docFont' = ("Times New Roman",8pt) 'FixedHeadingFont' = ("Arial",9pt,Bold); STYLE Table from Output / frame = hsides cellpadding = 0.021in cellspacing = 0in borderwidth = 0.01in; STYLE Body from Document / topmargin = 1.25in bottommargin = 1.00in rightmargin = 0.5in leftmargin = 0.5in; STYLE Header from Header / frame = hsides backgroundcolor = transparent borderwidth = 0.01in; END; PROC REPORT NOWD DATA=xxx MISSING SPLIT='~'; BY pagord.; COLUMN pagord xxx yyy zzz ; DEFINE pagord / ORDER NOPRINT ORDER=INTERNAL; DEFINE xxx / ORDER STYLE=[JUST=C WIDTH=1.1cm] "Xxxx"; DEFINE yyy / ORDER STYLE=[JUST=C CELLWIDTH=1.1cm] 'Yyyy'; DEFINE zzz / DISPLAY STYLE=[JUST=C CELLWIDTH=1.3cm] 'Zzzz'; RUN;
... View more