Date:         Fri, 27 Mar 2009 10:50:55 -0400
Reply-To:     Randy <randistan69@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Randy <randistan69@HOTMAIL.COM>
Subject:      Variation on the Groupings problem

Thanx for all the help in the earlier Groupings problem.
This is a variation on my earlier groupings question:
Flag1:   Where ID_B ID_C (as a unit) appears in a single ID_A on more than
one date
Flag2:   Where ID_B ID_C (as a unit) appears on more that one date
Flag3: Where ID_B ID_C (as a unit) appear in multiple ID_A's on multiple days.
Let me construct the example for you:


Date    ID_A    ID_B     ID_C     Flag1  Flag2  Flag3
Mar1     1        A        XA       1      1     1
Mar1     1        B        XA       0      0     0
Mar1     1        C        XA       0      1`    0
Mar1     2        A        XA       0      1     1
Mar1     2        E        AB       1      0     0
Mar1     2        G        XB       0      0     0
Mar2     1        A        XA       1      1     1
Mar2     2        A        XA       1      1     1
Mar2     3        C        XA       0      1     0
Mar2     4        F        XD       0      0     0
Mar2     2        E        XB       1      0     0

Thank you for all the help