set more off
use e:\DHS\DHS_data\IR_files\KHIR72FL.dta, clear
sort v001 v002 v003
gen in_IR_file=1
save e:\DHS\DHS_data\scratch\temp.dta, replace
ta
use e:\DHS\DHS_data\PR_files\KHPR72FL.dta, clear
rename hv001 v001
rename hv002 v002
rename hv112 v003
tab v003,m
drop if v003==.
gen child_in_PR_file=1
gen mother_in_hh=1
replace mother_in_hh=0 if v003==0

sort v001 v002 v003
merge v001 v002 v003 using e:\DHS\DHS_data\scratch\temp.dta

tab1 v003 *_file mother* _merge,m
drop if _merge==2

tab _merge mother_in_hh,m

drop _merge

* This file has one record per child
* hv variables refer to the child, v variables refer to the mother
* If the child's mother is not in the household, then mother_in_hh=0