Understanding Society User Support

joinby ${wave}hidp ${wave}pno using ${inpath}\${wave}indall${dta}, unmatched(using)

if ${cohort}== 1 {

cap drop ${wave}nchild_dv

cap gen ${wave}aivfio=.

cap gen ${wave}ivfio=.

}

recode ${wave}relationship_dv (.=0)

bys ${wave}hidp ${wave}pno: ///

egen ${wave}nchild_dv = sum((${wave}relationship_dv==9 | ${wave}relationship_dv==10 | ${wave}relationship_dv==12) ///

& ((${wave}aage_dv<16) | (${wave}aage_dv<0 & (${wave}ivfio>=21 & ${wave}ivfio<=24))))

lab var ${wave}nchild_dv "Number of own children in household"

bysort ${wave}hidp ${wave}pno: keep if _n==1

keep ${wave}hidp ${wave}pno ${wave}nchild_dv

lab var ${wave}pno "person number"

order ${wave}hidp ${wave}pno ${wave}nchild_dv

sort ${wave}hidp ${wave}pno

lab dat "Number of own children, person-level DV"

save ${outpath}/${wave}nchild_dv.dta , replace