Date:         Sat, 25 Dec 2004 18:50:52 -0800
Reply-To:     dexter_road@YAHOO.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         dexter_road@YAHOO.COM
Organization: http://groups.google.com
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*;


data final;

do x=1 to 36;
*** the last page of data must be exactly full - 36 lines will do it;


result=put(x,best.);

output;

end;

run;


ods escapechar='^' ;

options nodate nonumber missing=' ';

ods listing close;


ods rtf file="ExtraPage.rtf";

proc report data=final nowd
ls=132
ps=45 ;

columns result ;

define result / style=[just=center asis=on

cellwidth=0.6in ] "Total (N=999)";

run;

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
"(N=999)"
.

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.
Tammie Kirkland
dexter_road@yahoo.com