Date: Wed, 27 Jul 2011 20:34:59 +0000
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: Stats from more than 1 analysis variable in
Content-Type: text/plain; charset="utf-8"
Not tested, but something like the revised TABLE statement below might work for you. (You'll also have to add the second variable to your VAR statement, of course.)
TABLE (SEG1 ALL="Total")*(PAMOUNT NEWVAR), (SEG3 ALL="Total")*SUM="";
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Daniel Yanosky
Sent: Wednesday, July 27, 2011 3:31 PM
Subject: PROC TABULATE: Stats from more than 1 analysis variable in rows XXXX
I have the following PROC TABULATE code that works fine. However, I want to add the sum of another analysis variable underneath the sum of PAMOUNT in each cell. I have not been able to find an example of this yet.
PROC TABULATE DATA = FC1 MISSING FORMAT=COMMA20.2 NOSEPS;
CLASS SEG1 SEG3;
TABLE SEG1 ALL="Total", (SEG3 ALL="Total")*PAMOUNT=""*SUM="";
Any assistance is greatly appreciated!