LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous (more recent) messageNext (less recent) messagePrevious (more recent) in topicNext (less recent) in topicPrevious (more recent) by same authorNext (less recent) by same authorPrevious page (March 1998, week 5)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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 =================================


Back to: Top of message | Previous page | Main SAS-L page