I am working on creating a study sample using the South African 2001 Census and 2007 Community Survey data. The main variable of interest we are looking at is the number of children born alive who have died for each mother (CHBORN minus CHSURV). The sample we’d like to create would include all individuals identified as mothers, with "paternal’ (‘paternal’ as in the men who are fathers to her children) and child variables added on to each maternal record.
I found the sample SAS code for merging records based on family interrelationship available in the first End Note of the Family Interrelationships page to be very helpful. However, when I run this code, the new data set has a greater number of observations then the original. Can you help me figure out what is going wrong here?