Date: Sat, 15 Jan 2005 09:23:10 -0800
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Subject: Help on SAS Programming
Content-Type: text/plain; charset="big5"
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!!!