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 (June 2003, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Tue, 10 Jun 2003 01:50:50 -0700
Reply-To:   Lars Schulz <Schulz_L@WEB.DE>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   Lars Schulz <Schulz_L@WEB.DE>
Organization:   http://groups.google.com/
Subject:   proc report
Content-Type:   text/plain; charset=ISO-8859-1

Hello,

obviously my last posting was wrapped up a little bit. So here we go again.

I have an output produced with the help of proc report, whereby the proc report is embedded in a macro. The output of Total is produced by using retain and counting the numbers belonging to every group.

The proc report statement looks like this:

Proc report headline headskip panels=99 pspace=8 nowd; column var1 var2 var3 var4;

define var1/group noprint; define var2/width=30 'Group' flow; define var3 /width=10 'N'; define var4/width=10 '%';

break after var1/skip suppress;

I get an output like this (on one page):

Group N % Group N %

Group 1 - H 2 40 - A 4 40 - I 1 20 - B 4 40 ______ - C 2 20 Total 5 100 _____ Total 10 100 Group 3

Group 2 - D 8 40 - E 8 40 - G 4 20 ______ Total 20 100

Group 3 - G 2 40

But I would like to have an output where everything that belongs to the group is written on the same column resp. the same page. I would like to have an output, which looks more like this:

Group N % Group N %

Group 1 Group 3 - A 4 40 - G 2 40 - B 4 40 - H 2 40 - C 2 20 - I 1 20 _____ _______ Total 10 100 Total 5 100

Group 2 - D 8 40 - E 8 40 - F 4 20 _______ Total 20 100

Maybe somebody has an idea how this can be done with proc report.

Lars

P.S.: I hope this time it looks better. By the way thanks to everyone who informed me that my posting got muddled up.


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