22 lines
712 B
Plaintext
22 lines
712 B
Plaintext
clear all
|
|
cd c:\chililabdata\data
|
|
use household_head.dta
|
|
keep if hhd_eobserveid ==""
|
|
duplicates drop individid, force
|
|
gen round =substr( hhd_sobserveid,10,3)
|
|
drop hhd_episodeid hhd_sdate hhd_seventtype hhd_eobserveid hhd_edate hhd_eeventtype hhd_sobserveid
|
|
gen individkey = individid+round
|
|
sort individkey
|
|
merge 1:1 individkey using ..\newcode\data\std_occupation, keepusing(occupationid)
|
|
keep if _merge==3
|
|
drop _merge
|
|
merge 1:1 individkey using ..\newcode\data\std_education, keepusing(eduid)
|
|
keep if _merge==3
|
|
drop _merge
|
|
duplicates drop socialgpid, force
|
|
rename socialgpid householdid
|
|
sort householdid
|
|
rename eduid headeduid
|
|
rename occupationid headoccupationid
|
|
save ..\fertility\data\householdhead, replace
|