Date:         Fri, 21 Jun 2002 16:58:32 -0700
Reply-To:     YCF <s007422@CUHK.EDU.HK>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         YCF <s007422@CUHK.EDU.HK>
Organization: The Chinese University of Hong Kong
Subject:      Something about repeated counting

Hi all,
    First, thanks for all who helped me solve the above problems. And I
solve them completely!
   Now, I have a new problem: The dataset now just contains two columns like
this:
id                    month
s008133            03
s008133            04
s551744            01
s551744            02
s551744            02
a004122            04

     I want to make a summary table and the expected output is like this:
(It is counting the frequency of existence of each id in each month)
id                 JAN        FEB      MAR    APR     TOTAL
a004122        0            0            0           1             1
s008133        0            0            1           1             2
s551744        1            2            0           0             3

    I think this is not a difficult problem but I fail many times! Thanks
for your help!

YCF