***DERIVING RELATIONSHIP BREAKDOWN VARIABLE for the sample: fsample1X==1 (n=13,411) **this uses 'fsample1X' and 'father' only variables- details of how this was derived is in syntax 2: *"Deriving the sample for analysis 1 (same father-mother households s1-5)" *fsample1X is used because this is the sample of two-parent (mother-father) households ***SWEEP TWO (age 3 years) gen s2relbreak = 0 replace s2relbreak = 1 if bhmrnc00 ==2 replace s2relbreak = 1 if bhprnc00 ==2 label define s2relbreak 0 "not" 1 "relationship breakdown" label values s2relbreak s2relbreak label var s2relbreak "Proportion of hholds in which relationship has broken down, s2" **Generate variable to distinguish between household is intact/nelationship broken down & *households that are excluded for another reason: gen s2intact = 0 replace s2intact = 1 if s2relbreak == 1 replace s2intact = 2 if fsample2X ==1 & s2relbreak == 0 label define s2intact 0 "Hhold excluded for some other reason" 1 "relationship has broken down" 2 "Household is intact" label values s2intact s2intact label var s2intact "Is household intact in s2? (3 categories)" tab s2intact if fsample1X==1 *separating attrition from the 'exclude for other reason' group: gen s2intact_v2=s2intact label define s2intact_v2 0 "Hhold excluded for some other reason" 1 "relationship has broken down" 2 "Household is intact" label values s2intact_v2 s2intact_v2 label var s2intact_v2 "Is household intact in s2 - with hholds dropped out due to attrition separate" replace s2intact_v2 = 3 if s2intact_v2 ==0 & bdresp00 ==. label define s2intact_v2 3 "Household dropped out in s2 (attrition)" label values s2intact_v2 s2intact_v2 **Generate variable for subsample analysis (which includes the sample of intact and relationship breakdown *households only) gen s2relsamp = 0 replace s2relsamp = 1 if s2intact ==1 replace s2relsamp = 1 if s2intact ==2 label var s2relsamp "Binary: Household intact or broken down? s2" ***SWEEP 3 - deriving a binary variable that measures: relationship breakdown versus not gen s3relbreak = 0 replace s3relbreak = 1 if s2intact_v2==2 & cmfcre0a == 1 replace s3relbreak = 1 if s2intact_v2==2 & cmfcre0a == 2 replace s3relbreak = 1 if s2intact_v2==2 & cmfcre0a == 3 replace s3relbreak = 1 if s2intact_v2==2 & cmfcre0a == 4 replace s3relbreak = 1 if s2intact_v2==2 & cmfcre0a == 5 replace s3relbreak = 1 if s2intact_v2==2 & cmfcre0a == 95 replace s3relbreak = 1 if s2intact_v2==2 & cmfcre0a == 98 replace s3relbreak = 1 if s2intact_v2==2 & cmfcre0a == 99 replace s3relbreak = 1 if s2intact_v2==2 & cmfcre0a == -9 label define s3relbreak 0 "not" 1 "relationship breakdown", modify label values s3relbreak s3relbreak label var s3relbreak "Proportion of hholds in which relationship has broken down, s3" replace s3relbreak = 1 if s2intact_v2==1 *ADDING IN THE s2 'attrition' group: replace s3relbreak = 1 if cmfcre0a ==95 & s2intact_v2==3 replace s3relbreak = 1 if cmfcre0a ==98 & s2intact_v2==3 replace s3relbreak = 1 if cmfcre0a ==99 & s2intact_v2==3 replace s3relbreak = 1 if cmfcre0a ==-9 & s2intact_v2==3 replace s3relbreak = 1 if cmfcre0a ==-8 & s2intact_v2==3 **Generate variable that measures household is intact versus relationship has broken down, s3 gen s3intact = 0 replace s3intact = 1 if s3relbreak == 1 replace s3intact = 2 if fsample3X ==1 & s3relbreak==0 label define s3intact 0 "Hhold excluded for some other reason" 1 "relationship has broken down" 2 "Household is intact" label values s3intact s3intact label var s3intact "Is household intact in s3? (3 categories)" *REVISING s3intact to take account of s2 attrition households that move back into sweep 3 survey and are intact: *1) fathers who are PARTNERS in s1 and PARTNERS s3 replace s3intact = 2 if appnum00 ==1 & cppnum00 ==1 & s2intact_v2==3 & father2==1 & s3father2==1 replace s3intact = 2 if appnum00 ==2 & cppnum00 ==2 & ampnum00 ==1 & cmpnum00==1 & s2intact_v2==3 & father2==1 & s3father2==1 tab ampnum00 cmpnum00 if appnum00 ==3 & cppnum00 == 3 & cmfcre0a ==-1 & s2intact_v2==3 & father2==1 & s3father2==1 & fsample1X==1 replace s3intact = 2 if appnum00 ==3 & cppnum00 ==3 & ampnum00 ==1 & cmpnum00==1 & s2intact_v2==3 & father2==1 & s3father2==1 tab ampnum00 cmpnum00 if appnum00 ==2 & cppnum00 == 3 & s2intact_v2==3 & father2==1 & s3father2==1 & fsample1X==1 replace s3intact = 1 if ampnum00 ==1 & cmpnum== 1 & appnum00 ==3 & cppnum00 ==3 & ampnum00 ==1 & cmpnum00==1 & s2intact_v2==3 & father2==1 & s3father2==1 tab ampnum00 cmpnum00 if appnum00 ==2 & cppnum00 == 4 & s2intact_v2==3 & father2==1 & s3father2==1 & fsample1X==1 & mother1==1 & s3mother1==1 replace s3intact = 1 if appnum00 ==2 & cppnum00 ==4 & s2intact_v2==3 & father2==1 & s3father2==1 tab ampnum00 cmpnum00 if appnum00 ==4 & cppnum00 == 4 & s2intact_v2==3 & father2==1 & s3father2==1 & fsample1X==1 replace s3intact = 2 if appnum00 ==4 & cppnum00 ==4 & ampnum00 ==1 & cmpnum00==1 & s2intact_v2==3 & father2==1 & s3father2==1 tab ampnum00 cmpnum00 if appnum00 ==1 & cppnum00 == 5 & s2intact_v2==3 & father2==1 & s3father2==1 & fsample1X==1 replace s3intact = 1 if appnum00 ==1 & cppnum00 ==5 & s2intact_v2==3 & father2==1 & s3father2==1 tab ampnum00 cmpnum00 if appnum00 ==2 & cppnum00 == 5 & s2intact_v2==3 & father2==1 & s3father2==1 & fsample1X==1 replace s3intact = 1 if appnum00 ==2 & cppnum00 ==5 & s2intact_v2==3 & father2==1 & s3father2==1 tab ampnum00 cmpnum00 if appnum00 ==5 & cppnum00 == 5 & s2intact_v2==3 & father2==1 & s3father2==1 & fsample1X==1 & mother1==1 & s3mother1==1 replace s3intact = 2 if appnum00 ==5 & cppnum00 ==5 & ampnum00 ==1 & cmpnum00==1 & s2intact_v2==3 & father2==1 & s3father2==1 tab ampnum00 cmpnum00 if appnum00 ==6 & cppnum00 == 5 & s2intact_v2==3 & father2==1 & s3father2==1 & fsample1X==1 & mother1==1 & s3mother1==1 replace s3intact = 1 if appnum00 ==6 & cppnum00 ==5 & ampnum00 ==1 & cmpnum00==1 & s2intact_v2==3 & father2==1 & s3father2==1 tab cmfcre0a if appnum00 ==2 & cppnum00 == 7 & s2intact_v2==3 & father2==1 & s3father2==1 & fsample1X==1 replace s3intact = 1 if appnum00 ==2 & cppnum00 ==7 & ampnum00 ==1 & cmpnum00==1 & s2intact_v2==3 & father2==1 & s3father2==1 tab ampnum00 cmpnum00 if appnum00 ==6 & cppnum00 == 6 & s2intact_v2==3 & father2==1 & s3father2==1 & fsample1X==1 replace s3intact = 2 if appnum00 ==6 & cppnum00 ==6 & ampnum00 ==1 & cmpnum00==1 & s2intact_v2==3 & father2==1 & s3father2==1 tab cmfcre0a if appnum00 ==2 & cppnum00 == 8 & s2intact_v2==3 & father2==1 & s3father2==1 & fsample1X==1 replace s3intact = 1 if appnum00 ==2 & cppnum00 ==8 & ampnum00 ==1 & cmpnum00==1 & s2intact_v2==3 & father2==1 & s3father2==1 *2) fathers who are PARTNERS in s1 and MAINS s3 tab ampnum00 cppnum00 if appnum00 ==1 & cmpnum00 ==1 & s2intact_v2==3 & father2==1 & s3father1==1 & fsample1X==1 , miss replace s3intact = 2 if appnum00 ==1 & cmpnum00 ==1 & ampnum00 ==2 & cppnum00 ==2 & s2intact_v2==3 & father2==1 & s3father1==1 tab ampnum00 cppnum00 if appnum00 ==2 & cmpnum00 ==2 & s2intact_v2==3 & father2==1 & s3father1==1 & fsample1X==1 , miss replace s3intact = 2 if appnum00 ==2 & cmpnum00 ==2 & ampnum00 ==1 & cppnum00 ==1 & s2intact_v2==3 & father2==1 & s3father1==1 replace s3intact = 1 if appnum00 ==2 & cmpnum00 ==2 & ampnum00 ==1 & cppnum00 ==4 & s2intact_v2==3 & father2==1 & s3father1==1 replace s3intact = 1 if appnum00 ==2 & cmpnum00 ==2 & ampnum00 ==1 & cppnum00 ==. & s2intact_v2==3 & father2==1 & s3father1==1 tab ampnum00 cppnum00 if appnum00 ==6 & cmpnum00 ==6 & s2intact_v2==3 & father2==1 & s3father1==1 & fsample1X==1 , miss replace s3intact = 2 if appnum00 ==6 & cmpnum00 ==6 & s2intact_v2==3 & father2==1 & s3father1==1 *3) fathers who are main respondents in s1 and main respondents in s3 (and are n/a in cmfcre) gen s3intact_v2=s3intact label define s3intact_v2 0 "Hhold excluded for some other reason" 1 "relationship has broken down" 2 "Household is intact" label values s3intact_v2 s3intact_v2 label var s3intact_v2 "Is household intact in s3 - with hholds dropped out due to attrition separate" replace s3intact_v2 = 3 if s3intact_v2 ==0 & cdresp00 ==. label define s3intact_v2 3 "Household dropped out in s3 (attrition)" label values s3intact_v2 s3intact_v2 tab cmfcre0a s3intact if fsample1X==1 gen s3relsamp = 0 replace s3relsamp = 1 if s3intact ==1 replace s3relsamp = 1 if s3intact ==2 label var s3relsamp "Binary: household intact or broken down? s3" ***SWEEP 4 - deriving a binary variable that measures: relationship breakdown versus not gen s4relbreak = 0 replace s4relbreak = 1 if s3intact_v2==2 & dmfcre0a == -8 replace s4relbreak = 1 if s3intact_v2==2 & dmfcre0a == 1 replace s4relbreak = 1 if s3intact_v2==2 & dmfcre0a == 2 replace s4relbreak = 1 if s3intact_v2==2 & dmfcre0a == 3 replace s4relbreak = 1 if s3intact_v2==2 & dmfcre0a == 4 replace s4relbreak = 1 if s3intact_v2==2 & dmfcre0a == 5 replace s4relbreak = 1 if s3intact_v2==2 & dmfcre0a == 95 replace s4relbreak = 1 if s3intact_v2==2 & dmfcre0a == -9 label define s4relbreak 0 "not" 1 "relationship breakdown", modify label values s4relbreak s4relbreak label var s4relbreak "Proportion of hholds in which relationship has broken down, s4" replace s4relbreak = 1 if s3intact_v2==1 replace s4relbreak = 1 if dmfcre0a >0 & dmfcre0a <6 & s3intact_v2==3 replace s4relbreak = 1 if dmfcre0a ==95 & s3intact_v2==3 replace s4relbreak = 1 if dmfcre0a ==98 & s3intact_v2==3 replace s4relbreak = 1 if dmfcre0a ==99 & s3intact_v2==3 replace s4relbreak = 1 if dmfcre0a ==-9 & s3intact_v2==3 replace s4relbreak = 1 if dmfcre0a ==-8 & s3intact_v2==3 gen s4intact = 0 replace s4intact = 1 if s4relbreak == 1 replace s4intact = 2 if fsample4X ==1 & s4relbreak ==0 label define s4intact 0 "Hhold excluded for some other reason" 1 "relationship has broken down" 2 "Household is intact", modify label values s4intact s4intact label var s4intact "Is household intact in s4? (3 categories)" *REVISING s4intact to take account of s3 attrition households that move back into sweep 34survey and are intact: *fathers who are PARTNERS in s2 and PARTNERS in s4 replace s4intact = 2 if bppnum00 ==1 & dppnum00 ==1 & s3intact_v2==3 & s2father2==1 & s4father2==1 tab bmpnum00 dmpnum00 if bppnum00==2 & dppnum00 == 2 & s3intact_v2==3 & s2father2==1 & s4father2==1 & fsample1X==1 replace s4intact = 2 if bppnum00 ==2 & dppnum00 ==2 & s3intact_v2==3 & s2father2==1 & s4father2==1 tab bmpnum00 dmpnum00 if bppnum00==2 & dppnum00 == 3 & s3intact_v2==3 & s2father2==1 & s4father2==1 & fsample1X==1 replace s4intact = 1 if bppnum00 ==2 & dppnum00 ==3 & s3intact_v2==3 & s2father2==1 & s4father2==1 tab bmpnum00 dmpnum00 if bppnum00==3 & dppnum00 == 3 & s3intact_v2==3 & s2father2==1 & s4father2==1 & fsample1X==1 replace s4intact = 2 if bppnum00 ==3 & dppnum00 ==3 & s3intact_v2==3 & s2father2==1 & s4father2==1 tab bdpres00 dpdres00 if bppnum00==2 & dppnum00 == 4 & s3intact_v2==3 & s2father2==1 & s4father2==1 & fsample1X==1 & s2mother1==1 & s4mother1==1 replace s4intact = 1 if bppnum00 ==2 & dppnum00 ==4 & s3intact_v2==3 & s2father2==1 & s4father2==1 tab bmpnum00 dmpnum00 if bppnum00==4 & dppnum00 == 4 & s3intact_v2==3 & s2father2==1 & s4father2==1 & fsample1X==1 & s2mother1==1 & s4mother1==1 replace s4intact = 2 if bppnum00 ==4 & dppnum00 ==4 & s3intact_v2==3 & s2father2==1 & s4father2==1 tab bmpnum00 dmpnum00 if bppnum00==2 & dppnum00 == 6 & s3intact_v2==3 & s2father2==1 & s4father2==1 & fsample1X==1 & s2mother1==1 & s4mother1==1 replace s4intact = 1 if bppnum00 ==2 & dppnum00 ==6 & s3intact_v2==3 & s2father2==1 & s4father2==1 *Fathers who are PARTNERS in s2 and MAINS s4 tab bmpnum00 dppnum00 if bppnum00==1 & dmpnum00 == 1 & s3intact_v2==3 & s2father2==1 & s4father1==1 & fsample1X==1 replace s4intact = 2 if bppnum00 ==1 & dmpnum00 ==1 & s3intact_v2==3 & s2father2==1 & s4father1==1 replace s4intact = 2 if bppnum00 ==2 & dmpnum00 ==2 & bmpnum00==1 & dppnum00==1 & s3intact_v2==3 & s2father2==1 & s4father1==1 replace s4intact = 1 if bppnum00 ==2 & dmpnum00 ==2 & bmpnum00==1 & dppnum00==4 & s3intact_v2==3 & s2father2==1 & s4father1==1 tab bmpnum00 dppnum00 if bppnum00==5 & dmpnum00 == 5 & s3intact_v2==3 & s2father2==1 & s4father1==1 & fsample1X==1 & s2mother1==1 & s4mother2==1 replace s4intact = 2 if bppnum00 ==5 & dmpnum00 ==5 & s3intact_v2==3 & s2father2==1 & s4father1==1 tab bppnum00 dppnum00 if bmpnum00==1 & dmpnum00 == 1 & s3intact_v2==3 & s2father1==1 & s4father1==1 & fsample1X==1 & s2mother2==1 & s4mother2==1 replace s4intact = 2 if bmpnum00 ==1 & dmpnum00 ==1 & bppnum00==2 & dppnum00==2 & s3intact_v2==3 & s2father1==1 & s4father1==1 replace s4intact = 2 if bmpnum00 ==2 & dmpnum00 ==2 & bppnum00==1 & dppnum00==1 & s3intact_v2==3 & s2father1==1 & s4father1==1 tab bppnum00 dmpnum00 if bmpnum00 == 2 & dppnum00==2 & s3intact_v2==3 & s2father1==1 & s4father2==1 & fsample1X==1, miss replace s4intact = 2 if bmpnum00 ==2 & dppnum00 ==2 & bppnum00==1 & dmpnum00==1 & s3intact_v2==3 & s2father1==1 & s4father2==1 ***DOUBLE checks tab cppnum00 dppnum00 if s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab cmpnum00 dmpnum00 if cppnum00 ==1 & dppnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab cmfcre0a dmfcre0a if cppnum00 ==1 & dppnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab bhprnc bhmrnc if cppnum00 ==1 & dppnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab ddrspo00 if cppnum00 ==1 & dppnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab dmdres00 dpdres00 if cppnum00 ==1 & dppnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss replace s4intact = 2 if cppnum00 ==1 & dppnum00 ==1 & cmpnum00 ==2 & dmpnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1 tab cmpnum00 dmpnum00 if cppnum00 ==2 & dppnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab cmfcre0a dmfcre0a if cppnum00 ==2 & dppnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab ddrspo00 if cppnum00 ==2 & dppnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab dmdres00 dpdres00 if cppnum00 ==2 & dppnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss replace s4intact = 2 if cppnum00 ==2 & dppnum00 ==2 & cmpnum00 ==1 & dmpnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1 tab cmpnum00 dmpnum00 if cppnum00 ==4 & dppnum00 == 4 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab cmfcre0a dmfcre0a if cppnum00 ==4 & dppnum00 == 4 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab cdresp00 if cppnum00 ==4 & dppnum00 == 4 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab admres00 adpres00 if cppnum00 ==4 & dppnum00 == 4 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss replace s4intact = 2 if cppnum00 ==4 & dppnum00 ==4 & cmpnum00 ==1 & dmpnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1 tab cmpnum00 dmpnum00 if cppnum00 ==5 & dppnum00 == 5 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab cmfcre0a dmfcre0a if cppnum00 ==5 & dppnum00 == 5 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab adresp00 if cppnum00 ==5 & dppnum00 == 5 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss tab admres00 adpres00 if cppnum00 ==5 & dppnum00 == 5 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1, miss replace s4intact = 2 if cppnum00 ==5 & dppnum00 ==5 & cmpnum00 ==1 & dmpnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father2==1 & s3mother1==1 & s4mother1==1 **s3 PARTNER to S4 MAIN fathers intact in s3 replace s4intact = 2 if cppnum00 ==1 & dmpnum00 == 1 & cmpnum ==2 & dppnum ==2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father1==1 & s3mother1==1 & s4mother2==1 tab cmpnum00 dppnum00 if cppnum00 ==2 & dmpnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father1==1 & s3mother1==1 & s4mother2==1, miss tab cmfcre0a dmfcre0a if cppnum00 ==2 & dmpnum00 == 2 & cmpnum==1 & dppnum==1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father1==1 & s3mother1==1 & s4mother2==1, miss tab adresp00 if cppnum00 ==2 & dmpnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father1==1 & s3mother1==1 & s4mother2==1, miss tab admres00 adpres00 if cppnum00 ==2 & dmpnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father1==1 & s3mother1==1 & s4mother2==1, miss replace s4intact = 2 if cppnum00 ==2 & dmpnum00 == 2 & cmpnum ==1 & dppnum ==1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father2==1 & s4father1==1 & s3mother1==1 & s4mother2==1 tab cmpnum00 dmpnum00 if s3intact_v2 == 2 & s4intact_v2==0 & fsample1X==1 & s3father1==1 & s4father1==1 & s3mother2==1 & s4mother2==1 , miss tab cppnum00 dppnum00 if cmpnum00 ==2 & dmpnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father1==1 & s3mother2==1 & s4mother2==1 tab cmfcre0a dmfcre0a if cmpnum00 ==2 & dmpnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father1==1 & s3mother2==1 & s4mother2==1 tab ddrspo00 if cmpnum00 ==2 & dmpnum00 == 2 & s3intact_v2 == 2 & s4intact_v2==0 & fsample1X==1 & s3father1==1 & s4father1==1 & s3mother2==1 & s4mother2==1 tab dmdres00 dpdres00 if cmpnum00 ==2 & dmpnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father1==1 & s3mother2==1 & s4mother2==1 replace s4intact = 2 if cmpnum00 ==2 & dmpnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father1==1 & s3mother2==1 & s4mother2==1 **s3 MAIN to S4 PARTNER DADS intact in s3 tab cmpnum00 dppnum00 if s3intact_v2 == 2 & s4intact_v2==0 & fsample1X==1 & s3father1==1 & s4father2==1 & s3mother2==1 & s4mother1==1 , miss tab cppnum00 dmpnum00 if cmpnum00 ==1 & dppnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father2==1 & s3mother2==1 & s4mother1==1, miss tab cmfcre0a dmfcre0a if cmpnum00 ==1 & dppnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father2==1 & s3mother2==1 & s4mother1==1, miss tab ddrspo00 if cmpnum00 ==1 & dppnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father2==1 & s3mother2==1 & s4mother1==1, miss tab admres00 adpres00 if cmpnum00 ==1 & dppnum00 == 1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father2==1 & s3mother2==1 & s4mother1==1, miss replace s4intact = 2 if cmpnum00 ==1 & dppnum00 == 1 & cppnum00 ==2 & dmpnum==2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father2==1 & s3mother2==1 & s4mother1==1 tab cppnum00 dmpnum00 if cmpnum00 ==2 & dppnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father2==1 & s3mother2==1 & s4mother1==1, miss tab cmfcre0a dmfcre0a if cmpnum00 ==2 & dppnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father2==1 & s3mother2==1 & s4mother1==1, miss tab ddrspo00 if cmpnum00 ==2 & dppnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father2==1 & s3mother2==1 & s4mother1==1, miss tab dmdres00 dpdres00 if cmpnum00 ==2 & dppnum00 == 2 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father2==1 & s3mother2==1 & s4mother1==1, miss replace s4intact = 2 if cmpnum00 ==2 & dppnum00 == 2 & cppnum00 ==1 & dmpnum==1 & s3intact_v2 == 2 & s4intact==0 & fsample1X==1 & s3father1==1 & s4father2==1 & s3mother2==1 & s4mother1==1 **separating out the 'attrition' group in s4intact gen s4intact_v2=s4intact label define s4intact_v2 0 "Hhold excluded for some other reason" 1 "relationship has broken down" 2 "Household is intact", modify label values s4intact_v2 s4intact_v2 label var s4intact_v2 "Is household intact in s4 - with hholds dropped out due to attrition separate" replace s4intact_v2 = 3 if s4intact_v2 ==0 & ddrspo00 ==. label define s4intact_v2 3 "Household dropped out in s4 (attrition)", modify label values s4intact_v2 s4intact_v2 *****s4intact is recoded to 0 and 1 to use in the logistic regression predicting relationship breakdown: gen s4intactR = s4intact recode s4intactR 0=2 2=0 label define s4intactR 0 "Household intact" 1 "relationship has broken down" 2 "Hhold excluded for some other reason" label values s4intactR s4intactR label var s4intactR "Is household intact in s4 (3 categories)" drop s4intact **Generate variable for subsample analysis (which includes the sample of intact and relationship breakdown *households only) gen s4relsamp = 3 replace s4relsamp = 1 if s4intactR ==0 replace s4relsamp = 1 if s4intactR ==1 label var s4relsamp "Binary: household intact or broken down? s4" label define s4relsamp 1 "sample of intact/split households" 3 "Not in sample", modify label values s4relsamp s4relsamp ****LOGISTIC REGRESSION MODELS for predicting relationship breakdown - Norman, Elliot and Fagan - paper forthcoming. **for derivation of independent variables, see syntax 3 **MODEL 1(a) xi: svy, sub(fsample1X): logistic s4intactR i.fathbabyD i.mgratt i.fathnapD i.fathgeupD i.fathfeedD i.s1cookR i.s1launR i.s1cleanR /// i.marital mothage1 i.agediffc i.sexcc i.sibs1 i.grdiffc i.mothcple_C i.birthf i.medagec i.fatheducat i.ethn i.mothhours1 /// i.fathemp i.incomeC i.mothwkdD i.jobpreg i.caesar i.birwgt i.live if s4relsamp ==1 *diagnostic tests collin marital mothage1 agediffc sexcc sibs1 grdiffc mothcple_C birthf medagec fatheducat ethn mothhours1 /// fathemp incomeC mothwkdD jobpreg caesar birwgt live if s4relsamp ==1 linkest **MODEL 2(b) xi: svy, sub(fsample1X): logistic s4intactR i.fathbabyD i.mgratt i.fathnapD i.fathgeupD i.fathfeedD i.s1cookR i.s1launR i.s1cleanR /// i.marital mothage1 i.agediffc i.sexcc i.sibs1 i.grdiffc i.mothcple_C i.birthf i.medagec i.fatheducat i.mothhours1 /// i.fathemp i.incomeC i.mothwkdD i.jobpreg i.caesar i.birwgt i.live if s4relsamp ==1