30 lines
689 B
Plaintext
30 lines
689 B
Plaintext
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
|