I have a national father and kids dataset and want to create a variable FAMILY to show the members of the same family. For example, if POSTALCODE, CITY, STATE, and LAST NAME observations are the same then FAMILY = j (where j would be the number of families in my dataset); also I want to sort the members of the same family from older age to younger age. For example, FAMILY = 1 and FAMILY_ORDER = 1 for the father, FAMILY_ORDER = 2 for the oldest kid, FAMILY_ORDER = 3 for the next kid and so on to cover all members of the same family. How may I create these two variables?
Thanks
... View more