Dear all,

I am having trouble creating summary tables using aggregate function.

given the following table:


Var1   Var2    Var3   dummy
S1       T1         I         1
S1       T1         I         1
S1       T1         D        1
S1       T1         D        1
S1       T2         I         1
S1       T2         I         1
S1       T2         D        1
S1       T2         D        1
S2       T1         I         1
S2       T1         I         1
S2       T1         D        1
S2       T1         D        1
S2       T2         I         1
S2       T2         I         1
S2       T2         I        1
S2       T2         I        1


I want to create a summary table that shows for each category of Var1,
Var2, the number of cells that are Var3=D and Var3-I :

         Var1 Var2  Var3(D)   Var3(I)
         S1     T1    2              2
         S1     T2    2              2
         S2     T1    2              2
         S2     T2    0              4



However, if I do: Count.Cells=  aggregate(dummy~ Var1+Var2+Var3, FUN='sum')
, I get:

           Var1 Var2  Var3 Count of Resp
            S1     T1     D        2
            S1     T1     I          2
            S1     T2     D        2
            S1     T2     I         2
            S2     T1     D       2
            S2      T1    I        2
            S2     T2     I        4


Is there a way to get different columns for each Var3 level?


Thank you for any help you can give!

	[[alternative HTML version deleted]]

