Date:         Sun, 2 May 2004 09:34:16 -0700
Reply-To:     sportsfun <sportsfun77@HOTMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         sportsfun <sportsfun77@HOTMAIL.COM>
Organization: http://groups.google.com
Subject:      Find out all firms with the same id and same icode
Content-Type: text/plain; charset=ISO-8859-1

Hi,

My data looks like this:

ID     ICODE    NUM;
1000    2000      3
1000    2000      3
1000    2000      3
1001    2020      2
1001    1010      2
1002    1010      3
1002    1010      3
1002    1020      3

ID is the firm id, ICODE is another variable, NUM is the number of
firms that share the same id. I want to find out that for all firms
that share the same id, if they also share the same icode (for example
for id 1000), I will put them in a separate dataset. For all the other
firms (e.g., id 1001 and 1002), not all the firms share the same id
also share the same icode, I will put them in a different dataset. How
can I do this?

Thanks a lot!

Fun