Date:         Thu, 28 Jul 2011 10:29:17 -0400
Reply-To:     Daniel Yanosky <dyanosky@KENNESAW.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Daniel Yanosky <dyanosky@KENNESAW.EDU>
Subject:      Re: PROC TABULATE: Stats from more than 1 analysis variable in
              rows              XXXX
Comments: To: Mike Rhoads <RHOADSM1@WESTAT.com>
In-Reply-To:  <D47ACC3DC1D6CA4D85DE61DC39DA319F05F3DA@EX10MAIL3.westat.com>
Content-Type: text/plain; charset=utf-8

Hi Mike,

I tried this and got the following error. Any ideas?


1593!     PROC TABULATE DATA = FC1 MISSING FORMAT=COMMA20.2 NOSEPS;
1594      CLASS SEG1 SEG3;
1595      VAR PAMOUNT;
1596      TABLE (SEG1 ALL="Total")*(PAMOUNT OBALANCE), (SEG3 ALL="Total")*SUM="";
1597  RUN;

ERROR: The type of name (OBALANCE) is unknown.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE TABULATE used (Total process time):
      real time           0.35 seconds
      cpu time            0.01 seconds



----- Original Message -----
From: "Mike Rhoads" <RHOADSM1@WESTAT.com>
To: "Daniel Yanosky" <dyanosky@KENNESAW.EDU>, SAS-L@LISTSERV.UGA.EDU
Sent: Wednesday, July 27, 2011 4:34:59 PM
Subject: RE: PROC TABULATE: Stats from more than 1 analysis variable in rows              XXXX

Daniel,

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="";

HTH!


Mike Rhoads
RhoadsM1@Westat.com


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Daniel Yanosky
Sent: Wednesday, July 27, 2011 3:31 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: PROC TABULATE: Stats from more than 1 analysis variable in rows XXXX

Hello everyone,

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;
        VAR PAMOUNT;
        TABLE SEG1 ALL="Total", (SEG3 ALL="Total")*PAMOUNT=""*SUM="";
RUN;

Any assistance is greatly appreciated!

Thanks!

Daniel