LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2002, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Fri, 13 Sep 2002 23:14:51 GMT
Reply-To:     "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Organization: EarthLink Inc. -- http://www.EarthLink.net
Subject:      Re: Missing in proc report (resend)
Content-Type: text/plain;

"Huang, Ya" <ya.huang@PFIZER.COM> wrote in message news:6300328FB7CFD511AACF0002A589357D024C858F@lajgrdexm04.agouron.com...

snip

> expected result: > > Id > Cat1 > Cat2 Start > ------------------------ > ID= 1 > abcd > mkj > 2 > xyz > 1 > > ID= 2 > bcde > sdfasdf > 1 > 2 > 3 > > ID= 3 > > ID= 4 > > Thanks > > Ya

This type of class level indented report is highly desirable yet annoyingly un Proc REPORT. The big problem is the LINE statement in the compute blocks. LINE is unconditional and thus always puts out something even if you don't want it to.

Using ODS destinations, you can accumulate to a string the class level values you want to present in the break afters and output a line in the final break after. In each break after with a class level value you want to show, you need to append to your string the ODS inline directive \n followed by the indentation amount of spaces and the class level value. The line cell should also be styled 'asis'.

-- Richard A. DeVenezia http://www.devenezia.com/downloads/sas/macro


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