Date:         Fri, 16 Apr 2004 11:10:28 GMT
Reply-To:     Richard Liu <kataliu@EARTHLINK.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Richard Liu <kataliu@EARTHLINK.NET>
Organization: EarthLink Inc. -- http://www.EarthLink.net
Subject:      "proc tabulate" question

Dear SAS group,

I have a quick question about "PROC TABULATE"...

If I have a data set which looks like..

C1     C2     V1     V2     V3    (Field Name)
-----------------------------------
A      X         2.4       1.2        200
B      Y        5.6        3.3        124
....................
.......


and  I use

PROC TABULATE DATA = ....;
CLASS C1 C2;
VAR V1;
TABLES
  C1, C2*V1;

RUN;

then for V1 I have

                           C2
                ----------------
                X        Y        Z
          ------------------------
        A    N1.....
C1   B    ............
        D  ....................

N1 is the sum in the first cell as we know,
Same statement for N2 if I replace V1 by V2...


But if I would like to have

                           C2
                ----------------
                X        Y        Z
          ------------------------
        A    R1.....
C1   B    ............
        D  ....................

where R1 = sum(V1)/sum(V2), not sum(V1/V2)

What should I do for the proc tabulate?


Thank you for the generous answers!!