Family Data » Creating Parent Files with One Record Per Respondent »
Stata Code for: [2000] [1998] [1996] [1994] [1992]
Respondent Record with Mother and Father Variables: 2000
Note: Modify variable list as needed; for a listing of parent (and equivalent parent-in-law) variables consult the 2000 Parent to Parent-in-Law Variables Cross-Reference Table .
* STEP 1: PARENT INFORMATION FOR FAMILY RESPONDENTS' PARENTS use c:\temp\H00D_H keep if GPN_FAM~="" gen PN =GPN_FAM gen GPN_SP=GPN_NFAM * KEEP PARENT VARIABLES OF INTEREST keep HHID PN GPN_SP GSUBHH G2122 G2132 save FAMR, replace * STEP 2: PARENT INFORMATION FOR NON-FAMILY RESPONDENTS' PARENTS use c:\temp\H00D_H keep if GPN_NFAM~="" gen PN =GPN_NFAM gen GPN_SP=GPN_FAM * COPY PARENT-IN-LAW VARIABLES TO OUTPUT VARIABLES LOCATIONS replace G2122=G2309 replace G2132=G2319 * KEEP PARENT VARIABLES OF INTEREST keep HHID PN GPN_SP GSUBHH G2122 G2132 sort HHID PN save NFAMR, replace * Step 3: Concatenate two parent files use famr sort HHID PN merge HHID PN using nfamr drop _merge sort HHID PN save parents2, replace
Respondent Record with Mother and Father Variables: 1998
Note: Modify variable list as needed; for a listing of parent (and equivalent parent-in-law) variables consult the 1998 Parent to Parent-in-Law Variables Cross-Reference Table .
* STEP 1: PARENT INFORMATION FOR FAMILY RESPONDENTS' PARENTS use c:\temp\H98D_H keep if FPN_FAM~="" gen PN =FPN_FAM gen FPN_SP=FPN_NFAM * KEEP PARENT VARIABLES OF INTEREST keep HHID PN FPN_SP FSUBHH F1906 F1916 save FAMR, replace * STEP 2: PARENT INFORMATION FOR NON-FAMILY RESPONDENTS' PARENTS use c:\temp\H98D_H keep if FPN_NFAM~="" gen PN =FPN_NFAM gen FPN_SP=FPN_FAM * COPY PARENT-IN-LAW VARIABLES TO OUTPUT VARIABLES LOCATIONS replace F1906=F2068 replace F1916=F2078 * KEEP PARENT VARIABLES OF INTEREST keep HHID PN FPN_SP FSUBHH F1906 F1916 sort HHID PN save NFAMR, replace * STEP 3: CONCATENATE TWO PARENT FILES use famr sort HHID PN merge HHID PN using nfamr drop _merge sort HHID PN save parents2, replace
Respondent Record with Mother and Father Variables: 1996
Note: Modify variable list as needed; for a listing of parent (and equivalent parent-in-law) variables consult the 1996 Parent to Parent-in-Law Variables Cross-Reference Table .
* STEP 1: PARENT INFORMATION FOR FAMILY RESPONDENTS' PARENTS use c:\temp\H96D_H keep if EPN_FAM~="" gen PN =EPN_FAM gen EPN_SP=EPN_NFAM * KEEP PARENT VARIABLES OF INTEREST keep HHID PN EPN_SP ESUBHH E1557_1 E1566_1 save FAMR, replace * STEP 2: PARENT INFORMATION FOR NON-FAMILY RESPONDENTS' PARENTS use c:\temp\H96D_H keep if EPN_NFAM~="" gen PN =EPN_NFAM gen EPN_SP=EPN_FAM * COPY PARENT-IN-LAW VARIABLES TO OUTPUT VARIABLES LOCATIONS replace E1557_1=E1557_2 replace E1566_1=E1566_2A * KEEP PARENT VARIABLES OF INTEREST keep HHID PN EPN_SP ESUBHH E1557_1 E1566_1 sort HHID PN save NFAMR, replace * STEP 3: CONCATENATE TWO PARENT FILES use famr sort HHID PN merge HHID PN using nfamr drop _merge sort HHID PN save parents2, replace
Respondent Record with Mother and Father Variables: 1994
* REFORMAT PARENTS FILE TO ONE PER RESPONDENT * STEP 1: SORT W2PARS FILE use c:\temp\w2pars, clear sort HHID PN CSUBHH save w2parst, replace * STEP 2: CREATE FILE WITH MOTHER RECORDS use w2parst keep if CPARCODE == "1" rename W8201 W8201M rename W8202 W8202M rename W8203 W8203M rename W8204 W8204M rename W8205 W8205M rename W8206 W8206M rename W8207 W8207M rename W8208 W8208M rename W8209 W8209M rename W8210 W8210M rename W8211 W8211M rename W8213 W8213M rename W8214 W8214M rename W8215 W8215M rename W8216 W8216M rename W8217 W8217M rename W8218 W8218M rename W8219 W8219M keep HHID PN CSUBHH ASUBHH CPN_SP COPN_CS CCSR CFAMR CFINR RPN FAMFLAG W8201M W8202M W8203M W8204M W8205 W8206M W8207M W8208M W8209M W8210M W8211M W8213M W8214M W8215 W8216M W8217M W8218M W8219M save mom, replace * STEP 3: CREATE FILE WITH FATHER RECORDS use w2parst keep if CPARCODE == "2" rename W8201 W8201F rename W8202 W8202F rename W8203 W8203F rename W8204 W8204F rename W8205 W8205F rename W8206 W8206F rename W8207 W8207F rename W8208 W8208F rename W8209 W8209F rename W8210 W8210F rename W8211 W8211F rename W8213 W8213F rename W8214 W8214F rename W8215 W8215F rename W8216 W8216F rename W8217 W8217F rename W8218 W8218F rename W8219 W8219F keep HHID PN CSUBHH ASUBHH CPN_SP COPN_CS CCSR CFAMR CFINR RPN FAMFLAG W8201F W8202F W8203F W8204F W8205 W8206F W8207F W8208F W8209F W8210F W8211F W8213F W8214F W8215 W8216F W8217F W8218F W8219F save dad, replace * STEP 4: CREATE FILE WITH PARENT RECORDS use w2parst keep if CPARCODE == "3" rename W8209 W8209P rename W8210 W8210P rename W8211 W8211P rename W8212 W8212P rename W8213 W8213P rename W8214 W8214P rename W8215 W8215P rename W8216 W8216P rename W8217 W8217P rename W8218 W8218P rename W8219 W8219P keep HHID PN CSUBHH ASUBHH CPN_SP COPN_CS CCSR CFAMR CFINR RPN FAMFLAG W8209P W8210P W8211P W8212P W8213P W8214P W8215 W8216P W8217P W8218P W8219P save parent, replace * STEP 5: MERGE MOTHER FATHER AND PARENT FILES use parent sort HHID PN CSUBHH merge HHID PN CSUBHH using mom drop _merge sort HHID PN CSUBHH merge HHID PN CSUBHH using dad drop _merge sort HHID PN CSUBHH save parent2, replace
Respondent Record with Mother and Father Variables: 1992
* REFORMAT PARENTS FILE FROM ONE PER PARENT TO ONE PER RESPONDENT * STEP 1: SORT PARENTS FILE use c:\temp\parents sort HHID PN save parent1, replace * STEP 2: CREATE FILE WITH MOTHER RECORDS use parent1 keep if ATYPEPAR == "1" rename V8201 V8201M rename V8202 V8202M rename V8203 V8203M rename V8204 V8204M rename V8205 V8205M rename V8206 V8206M rename V8207 V8207M rename V8208 V8208M rename V8209 V8209M rename V8210 V8210M rename V8211 V8211M rename V8212 V8212M rename V8213 V8213M rename V8214 V8214M rename V8215 V8215M rename V8216 V8216M rename V8217 V8217M rename V8218 V8218M rename V8219 V8219M rename V8220 V8220M rename V8221 V8221M rename V8222 V8222M rename V8223 V8223M rename V8224 V8224M rename V18205 V18205M rename V18206 V18206M rename V18207 V18207M rename V18208 V18208M rename V18209 V18209M rename V18210 V18210M rename V18211 V18211M rename V18213 V18213M rename V18214 V18214M rename V18215 V18215M rename V18216 V18216M rename V18217 V18217M rename V18218 V18218M rename V18219 V18219M rename V18220 V18220M rename V18221 V18221M rename V18222 V18222M rename V18223 V18223M rename V18224 V18224M keep HHID PN ASUBHH APN_SP AFAMR AFINR V1 V2 V3 V8201M V8202M V8203M V8204M V8205M V8206M V8207M V8208M V8209M V8210M V8211M V8212M V8213M V8214M V8215M V8216M V8217M V8218M V8219M V8220M V8221M V8222M V8223M V8224M V18205M V18206M V18207M V18208M V18209M V18210M V18211M V18213M V18214M V18215M V18216M V18217M V18218M V18219M V18220M V18221M V18222M V18223M V18224M save mothers, replace * STEP 3: CREATE FILE WITH FATHER RECORDS use parent1 keep if ATYPEPAR=="2" rename V8201 V8201F rename V8202 V8202F rename V8203 V8203F rename V8204 V8204F rename V8205 V8205F rename V8206 V8206F rename V8207 V8207F rename V8208 V8208F rename V8209 V8209F rename V8210 V8210F rename V8211 V8211F rename V8212 V8212F rename V8213 V8213F rename V8214 V8214F rename V8215 V8215F rename V8216 V8216F rename V8217 V8217F rename V8218 V8218F rename V8219 V8219F rename V8220 V8220F rename V8221 V8221F rename V8222 V8222F rename V8223 V8223F rename V8224 V8224F rename V18205 V18205F rename V18206 V18206F rename V18207 V18207F rename V18208 V18208F rename V18209 V18209F rename V18210 V18210F rename V18211 V18211F rename V18213 V18213F rename V18214 V18214F rename V18215 V18215F rename V18216 V18216F rename V18217 V18217F rename V18218 V18218F rename V18219 V18219F rename V18220 V18220F rename V18221 V18221F rename V18222 V18222F rename V18223 V18223F rename V18224 V18224F keep HHID PN ASUBHH APN_SP AFAMR AFINR V1 V2 V3 V8201F V8202F V8203F V8204F V8205F V8206F V8207F V8208F V8209F V8210F V8211F V8212F V8213F V8214F V8215F V8216F V8217F V8218F V8219F V8220F V8221F V8222F V8223F V8224F V18205F V18206F V18207F V18208F V18209F V18210F V18211F V18213F V18214F V18215F V18216F V18217F V18218F V18219F V18220F V18221F V18222F V18223F V18224F save fathers, replace * STEP 4: MERGE MOTHER AND FATHER FILES use fathers sort HHID PN merge HHID PN using mothers drop _merge sort HHID PN save parents2, replace