**Merging household on women dataset** **Round 2** use "D:\Desktop\dhs\data\nfhs\2\IAHR42FL.DTA", clear gen int v001 = hv001 gen int v002 = hv002 gen byte v003 = hv003 sort v001 v002 v003 save "D:\Dropbox\stata\nfhs\IAHR42FL_sort.DTA", replace use "D:\Desktop\dhs\data\nfhs\2\IAIR42FL.DTA", clear sort v001 v002 v003 merge v001 v002 v003 using "D:\Dropbox\stata\nfhs\IAHR42FL_sort.DTA" save "D:\Desktop\dhs\data\nfhs\2\IA_HR_IR_42FL.DTA", replace
cd e:\DHS\DHS_data\scratch use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\IAIR42FL.DTA" , clear gen hv024=v024 gen hv001=v001 gen hv002=v002 gen hvidx=v003 gen in_IR=1 sort hv024 hv001 hv002 hvidx save IAIR42_temp.dta, replace use "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\IAPR42FL.DTA" , clear sort hv024 hv001 hv002 hvidx merge hv024 hv001 hv002 hvidx using IAIR42_temp.dta replace in_IR=0 if in_IR==. tab _merge tab _merge in_IR