Date: Sat, 25 Dec 2004 18:50:52 -0800
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Extra blank page at end with Proc Report/ODS RTF
Content-Type: text/plain; charset="iso-8859-1"
I'm creating summary tables of adverse events for a clinical trial and
am seeing an extra blank page at the end of one of my tables. I have
(simplified) code that will replicate the problem and it seems to be
very much related to multiple header lines for a single column.
I first noticed this on Vax/VMS running SAS 8.2 (don't have access
right now to get the long version) but was able to replicate on SAS/LE
on my PC at home (sysvlong is *8.02.02M0P012301*)
Does anyone have a workaround? Does the problem occur in version 9?
This code replicates the problem ----->
%put sysvlong is *&sysvlong*;
do x=1 to 36;
*** the last page of data must be exactly full - 36 lines will do it;
ods escapechar='^' ;
options nodate nonumber missing=' ';
ods listing close;
ods rtf file="ExtraPage.rtf";
proc report data=final nowd
columns result ;
define result / style=[just=center asis=on
cellwidth=0.6in ] "Total (N=999)";
ods rtf close;
ods listing ;
<---------- end of code;
The problem is not linked to
a split character, but merely to the split. In my original code, the
column is wider, but there is an explicit split between "Total" and
I couldn't find this problem listed on the SAS support site, but my
search terms are often lacking. If anyone sees a patch or knows of a
workaround, I'd be very happy to hear of it.