| 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.
|