Date:         Tue, 16 Oct 2001 09:41:30 -0400
Reply-To:     Mike Rhoads <RHOADSM1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mike Rhoads <RHOADSM1@WESTAT.COM>
Subject:      Re: Proc Tabulate question
Comments: To: Ron Smith <rsmith@PCC.EDU>
Content-Type: multipart/mixed;

[multipart/alternative]

Ron,

In Version 8, you can use "multilabel formats" to get embedded subtotals in
PROC TABULATE.  Check out Example 4 in the PROC TABULATE chapter of the
documentation.

Mike Rhoads
Westat
RhoadsM1@Westat.com

-----Original Message-----
From: Ron Smith [mailto:rsmith@PCC.EDU]
Sent: Monday, October 15, 2001 6:07 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc Tabulate question


I have a question.  All of my PROC TABULATE work has been in V 6.12 or
earlier, so there are probably new things I know nothing about, but am
heading to on-line documentation now to search.

This code:

proc tabulate format=6.0;

class CAMPUS DIV q2;

table  CAMPUS=' ',

DIV=' ' all='All Returned Surveys',

q2='Primary Reason for Attending PCC'*(n pctn<q2>*f=6.1) all;

keylabel  pctn ='%';

creates the tables.  The problem is this:  I have multiple levels of DIV.  I
want a row
that would give me a subtotal for all but two of the levels of DIV, then
rows for those two levels
and then an ALL row that would give me the totals.  I do not know how to do
the subtotal row, or
how to do an all row that would not add the subtotal row (which would double
count the rows going into
the subtotal calculation.

the layout for each campus would be something like this:


                          answer1             answer2           answer3
answer4
                        N       PCTN        N       PCTN       N       PCTN
N       PCTN
DIV (1)
Div (2)
Div (3)
Div (4)
  Subtotal (sum of Div1-Div4)
Div (5)
Div (6)
All (sum of Div1-Div6)

Thanks in advance

**********************************************************
Ronald Smith
Research Evaluation Coordinator
Institutional Research
Portland Community College
P. O. Box 19000, Portland, OR  97280-0990
Tel: (503) 614-7706; Fax: (503) 645-0894
rsmith@pcc.edu
**********************************************************


[text/html]