| Date: | Sat, 16 Oct 1999 10:02:48 GMT |
| Reply-To: | Richard Ferris <rferris@RXREMEDY.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Richard Ferris <rferris@RXREMEDY.COM> |
| Organization: | @Home Network |
| Subject: | Row percentages in a TABULATE procedure |
|---|
I would like to run a Tabulate which has subtotals in the columns and I want
to get row percentages as a percent of the entire row total, not the
subtotal. Here is a simple example of what I have tried:
Data temp;
input a b c;
1 1 1
1 1 2
2 1 1
2 1 2
1 2 1
1 2 2
2 2 1
2 2 2
;
Proc tabulate;
class a b c;
table a,b*c*pctn<a>;
run;
The row percentages under c add up to 100% for each b group. The b
percentages are percentages of the entire row. What I would like is to have
both the c percentages and the b percentages as a percentage of the row
total. Is there a simple way to do this?
Thanks.
Richard Ferris
Rx Remedy, Inc.
rferris@rxremedy.com
|