set more off set maxvar 10000 use ...IAHR74FL.DTA" , clear drop *_* sort hv024 hv001 hv002 save ...IAHRtemp.dta, replace use ...IAIR74FL.DTA" , clear gen rn=uniform() sort v024 v001 v002 rn egen sequence=seq(), by(v024 v001 v002) tab sequence keep if sequence==1 gen hv024=v024 gen hv001=v001 gen hv002=v002 sort hv024 hv001 hv002 merge hv024 hv001 hv002 using e:\DHS\DHS_data\scratch\IAHRtemp.dta keep if _merge==3 drop sequence _merge