Date: Wed, 18 Sep 1996 13:53:49 -0400
Reply-To: Ken Hardy 20 Manning Hall <khardy@FROSTY.IRSS.UNC.EDU>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Ken Hardy 20 Manning Hall <khardy@FROSTY.IRSS.UNC.EDU>
Subject: PROC TABULATE--ow to get percentages to sum to 100 across?
Dear PROC TABULATE gurus (Are you out there Dan?),
Should probably know this but can't remember and don't have much time to
RTFM or peruse Dan Brun's fine set of papers.
I have a table statement that looks like:
TABLE (ALL var1 var2 var3)*(PCTN),var4 ;
The percentages for each row variable (var1,var2,var3) in the table add to
100 over _all combinations of row and column values_ for a given row
variable. What I need is to have them add to 100 for _each value_ like
var4
1 2 3
var1
1 60 20 20 100
2 20 50 30 100
Any code fragments or pointers to manual or Proceedings pages appreciated.
As always thanks in advance.
Ken Hardy
+-------------------------------------------------------------------------+
| Kenneth A. Hardy | KEN_HARDY@UNC.EDU |
| Assoc. Dir. for Information Systems | or |
| Inst. for Research in Social Science | KHARDY@GIBBS.OIT.UNC.EDU |
| University of North Carolina | |
| Manning Hall CB#3355 | Voice: 919-966-4791 |
| Chapel Hill, N.C. 27599-3355 | FAX: 919-962-IRSS |
+-------------------------------------------------------------------------+