cd "L:\BD_2011_DHS_09222018_2331_124054\BDHR61DT" use "BDHR61FL.dta", clear rename hv001 v001 rename hv002 v002 sort v001 sort v002 keep v001 v002 hv252 save "BDHR61FLlabelledtomergesecondtry.dta", replace use "L:\BD_2011_DHS_09222018_2331_124054\BDIR61DT\BDIR61FL.DTA", clear sort v001 sort v002 merge 1:m v001 v002 using "BDHR61FLlabelledtomergesecondtry.dta" //could be 1 to many