clear all
set mem 800M
cd data
use pregnance
drop fatherid
gen socialgpid = substr(sobserveid,1,9)
gen quarterdate = qofd(preg_sdate)
tostring quarterdate, gen(key)
replace key = socialgpid + key
sort individid
merge individid using individual
keep if _merge ==3
drop eventid appround bornid individidGuid motheridGuid _merge sobserveid
sort key
save preg_all, replace
keep key
merge key using householdinfortemp.dta
keep if _merge !=2
drop _merge
sort key
save preg_houseinfo, replace
use preg_all
sort key
merge key using preg_houseinfo
keep if _merge !=2
drop _merge
drop  obs_de_date refdate period p refquarter maxobs_de_date dataClerk deDate fieldWrkr responsorID
save, replace
brow