Date: Tue, 31 Mar 1998 08:44:43 -0500
Reply-To: koen_vyverman@GOODYEAR.COM
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Koen Vyverman <koen_vyverman@GOODYEAR.COM>
Subject: Q: Eliminating certain breaklines from a proc report?
Content-Type: text/plain; charset=iso-8859-1
Hello,
I am running some rather lengthy and convoluted reports (using proc report)
with break-lines and sums after a number of subgroups. What bugs me is that the
lines with the totals are also generated after subgroups that consist of only
one line of data, resulting in unnecessary duplicate information, e.g.:
xx yy 100 150
-----------------
100 150
This makes a report look quite ugly, especially on pages where it happens a
lot. Now, before I resort to data step reporting, perhaps someone knows how to
tell proc report to display the break-lines only when appropriate? (i.e. when
there's more than 1 thing to be summed)
Using LINE statements in a compute-block doesn't really help as they cannot be
written conditionally. The best result I got using that approach was that the
lines with the dashes and the sums would be replaced by 2 extra blank lines
after each subgroup, resulting in an equally messy layout but wasting less ink
:-)
The details: SAS version 6.09 enhanced, MVS-TSO.
Cheers,
Koen.
=================================
Koen Vyverman
Electronic Data Systems
Currently @ Goodyear, Luxemburg :
koen_vyverman@goodyear.com
Phone: ++352 8199 8129
=================================
|