* rename variables and sort data for merging use "BUHW01FL.DTA", clear ren hwcaseid caseid ren hwline midx sort caseid midx save "BUHW01_temp.dta", replace * Sort the children's recode data and then merge use "BUKR01FL.DTA", clear sort caseid midx merge 1:1 caseid midx using "BUHW01_temp.dta" * Example tabulation of stunted by region gen stunted = (hc70<-200) if hc70 <9990 tab v101 stunted [iw=v005/1000000]
* Drop merge variable from previous run drop _merge * Copy cluster and household variables clonevar hhseg=v001 clonevar hhrugo=v002 * Merge data merge m:1 hhseg hhrugo using "BUHH01FL.dta", keep(match)
merge m:1 v001 v002 using "BUHW6FL_temp.dta"