Date: Thu, 15 Jul 2010 03:48:02 -0500
Reply-To: M D <tant07@GMAIL.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: M D <tant07@GMAIL.COM>
Subject: similar group identification
Content-Type: text/plain; charset=ISO-8859-1
Hi,
I have a problem and I am not sure what's the best way to solve.
My dataset looks like the following:
Group Company
1 A
1 B
1 C
2 A
2 Z
3 A
3 B
3 C
4 B
and so on...
I want to identify groups that are similar in structure. For example, in the
above example, group 1 and 3 are similar. In that case, I want to create a
new column identifying the similar groups in some fashion.
It will be great if you can help me with this.
Many thanks in advance.
Best,
Mike.
|