Date:         Sat, 15 Jan 2005 09:23:10 -0800
Reply-To:     hee_haa@YAHOO.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         hee_haa@YAHOO.COM
Organization: http://groups.google.com
Subject:      Help on SAS Programming
Content-Type: text/plain; charset="big5"

Hi All,

I have a little problem  in assigning a family ID for a group of data.
According to my database, I would like to assign a unique family_ID for
data with either same tel_no or same address.

For example, data as follow:
Policy  Tel_no   Address
P1       T1       A1
P2       T1       A2
P3       T2       A2
P4       T2       A3
P5       T3       A3
P6       T4       A4

I would like to identify P1 to P5 are actually from the same family. So
the output as follow:

Policy  Tel_no   Address   Family_ID
P1       T1       A1       F1
P2       T1       A2       F1
P3       T2       A2       F1
P4       T2       A3       F1
P5       T3       A3       F1
P6       T4       A4       F2
Would anyone kindly help me on this ...Thanks a lot!!!

holly