Dear Members,
I have been trying to merge 2 datasets. I have household sample and individual sample. Their sample sizes are different. I would like to merge variales in the hh sample with individual sample. HH sample includes 2 key variables: HV009 and HV010. I want HV009 HV010 variables to appear in my individual sample. To do this, I first opened my individual sample and run the following code:
merge 1:1 _n using "C:\Users\cansu\Desktop\Merging HH and Women\DHS-2018\2018 HH KEPT.dta"
drop if _merge==1
drop if _merge==2
Both samples has the same HHID number. I tried to match it based on HHID that appears both, but when I run this code, I see that the code fails. It does not correctlt matched. The only thing that I want is the exact match based on HHID number.
How should I solve this problem? Thank you very much in adcance.
This is my household sample as having an HHID number:
This is my individual sample where HHID is also available:
I have been trying to merge 2 datasets. I have household sample and individual sample. Their sample sizes are different. I would like to merge variales in the hh sample with individual sample. HH sample includes 2 key variables: HV009 and HV010. I want HV009 HV010 variables to appear in my individual sample. To do this, I first opened my individual sample and run the following code:
merge 1:1 _n using "C:\Users\cansu\Desktop\Merging HH and Women\DHS-2018\2018 HH KEPT.dta"
drop if _merge==1
drop if _merge==2
Both samples has the same HHID number. I tried to match it based on HHID that appears both, but when I run this code, I see that the code fails. It does not correctlt matched. The only thing that I want is the exact match based on HHID number.
How should I solve this problem? Thank you very much in adcance.
This is my household sample as having an HHID number:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str12 HHID double(HV009 HV010) " 01010004" 3 1 " 01010007" 4 1 " 01010008" 1 0 " 01010009" 4 1 " 01010011" 3 1 " 01010012" 4 0 " 01010013" 4 1 " 01010014" 5 1 " 01010016" 6 1 " 01010019" 5 1 " 01010021" 3 1 " 01020001" 1 0 " 01020002" 1 0 " 01020005" 2 0 " 01020006" 2 1 " 01020007" 2 0 " 01020010" 2 1 " 01020011" 1 0 " 01020013" 4 1 " 01020015" 2 1 " 01020017" 2 0 " 01030004" 2 1 " 01030007" 1 0 " 01030012" 3 2 " 01030014" 2 0 " 01030016" 4 2 " 01030018" 2 0 " 01030020" 2 0 " 01040002" 3 0 " 01040003" 4 1 " 01040004" 3 1 " 01040005" 2 0 " 01040006" 3 0 " 01040007" 1 0 " 01040008" 4 2 " 01040009" 4 2 " 01040010" 2 0 " 01040011" 4 1 " 01040013" 2 1 " 01040014" 5 1 " 01040015" 5 1 " 01040016" 2 0 " 01040018" 3 0 " 01040019" 1 0 " 01040020" 4 1 " 01050001" 3 2 " 01050003" 4 1 " 01050005" 3 1 " 01050010" 2 0 " 01050011" 3 1 " 01050014" 5 1 " 01050016" 4 1 " 01050019" 4 1 " 01050021" 4 0 " 01060001" 6 3 " 01060002" 6 2 " 01060003" 4 2 " 01060004" 4 0 " 01060005" 3 1 " 01060006" 9 2 " 01060007" 10 2 " 01060008" 4 0 " 01060009" 4 1 " 01060011" 1 0 " 01060012" 1 0 " 01060013" 3 1 " 01060014" 4 0 " 01060015" 5 2 " 01060017" 5 2 " 01060018" 5 2 " 01060019" 3 1 " 01060020" 3 1 " 01070002" 4 1 " 01070003" 4 1 " 01070005" 6 1 " 01070007" 3 0 " 01070008" 8 1 " 01070009" 4 1 " 01070010" 1 0 " 01070013" 4 1 " 01070015" 4 1 " 01070016" 2 1 " 01070017" 3 1 " 01070018" 4 0 " 01070019" 3 0 " 01070020" 4 1 " 01070021" 2 0 " 01080003" 2 0 " 01080005" 4 1 " 01080008" 3 1 " 01080009" 2 0 " 01080010" 4 0 " 01080011" 2 0 " 01080012" 1 1 " 01080013" 4 1 " 01080017" 4 0 " 01080018" 2 0 " 01080020" 1 0 " 01090001" 2 1 " 01090004" 2 0 end
This is my individual sample where HHID is also available:
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str15 CASEID str8 HHID str3 V000 " 01010004 02" "01010004" "TR7" " 01010007 02" "01010007" "TR7" " 01010011 02" "01010011" "TR7" " 01010013 03" "01010013" "TR7" " 01010014 02" "01010014" "TR7" " 01010016 02" "01010016" "TR7" " 01010021 02" "01010021" "TR7" " 01020006 01" "01020006" "TR7" " 01030004 01" "01030004" "TR7" " 01030012 02" "01030012" "TR7" " 01040003 02" "01040003" "TR7" " 01040004 02" "01040004" "TR7" " 01040008 02" "01040008" "TR7" " 01040008 04" "01040008" "TR7" " 01040009 02" "01040009" "TR7" " 01040009 03" "01040009" "TR7" " 01040011 02" "01040011" "TR7" " 01040013 02" "01040013" "TR7" " 01040014 02" "01040014" "TR7" " 01040015 05" "01040015" "TR7" " 01040020 02" "01040020" "TR7" " 01050001 01" "01050001" "TR7" " 01050003 02" "01050003" "TR7" " 01050011 03" "01050011" "TR7" " 01050014 02" "01050014" "TR7" " 01050016 02" "01050016" "TR7" " 01060002 02" "01060002" "TR7" " 01060002 04" "01060002" "TR7" " 01060003 02" "01060003" "TR7" " 01060005 02" "01060005" "TR7" " 01060006 03" "01060006" "TR7" " 01060006 07" "01060006" "TR7" " 01060007 05" "01060007" "TR7" " 01060007 06" "01060007" "TR7" " 01060009 01" "01060009" "TR7" " 01060013 02" "01060013" "TR7" " 01060015 02" "01060015" "TR7" " 01060015 03" "01060015" "TR7" " 01060017 02" "01060017" "TR7" " 01060017 04" "01060017" "TR7" " 01060018 01" "01060018" "TR7" " 01060020 02" "01060020" "TR7" " 01070002 02" "01070002" "TR7" " 01070003 02" "01070003" "TR7" " 01070005 02" "01070005" "TR7" " 01070008 02" "01070008" "TR7" " 01070009 02" "01070009" "TR7" " 01070016 02" "01070016" "TR7" " 01070017 03" "01070017" "TR7" " 01070020 02" "01070020" "TR7" " 01080005 02" "01080005" "TR7" " 01080008 02" "01080008" "TR7" " 01080012 01" "01080012" "TR7" " 01080013 03" "01080013" "TR7" " 01090001 02" "01090001" "TR7" " 01090009 02" "01090009" "TR7" " 01090014 01" "01090014" "TR7" " 01090015 02" "01090015" "TR7" " 01090020 03" "01090020" "TR7" " 01100003 02" "01100003" "TR7" " 01100004 04" "01100004" "TR7" " 01100008 02" "01100008" "TR7" " 01100012 03" "01100012" "TR7" " 01100017 02" "01100017" "TR7" " 01100018 02" "01100018" "TR7" " 01110001 02" "01110001" "TR7" " 01110002 01" "01110002" "TR7" " 01110002 02" "01110002" "TR7" " 01110002 03" "01110002" "TR7" " 01110003 03" "01110003" "TR7" " 01110004 02" "01110004" "TR7" " 01110009 02" "01110009" "TR7" " 01110010 01" "01110010" "TR7" " 01110013 02" "01110013" "TR7" " 01110016 01" "01110016" "TR7" " 01110016 02" "01110016" "TR7" " 01110019 02" "01110019" "TR7" " 01110021 02" "01110021" "TR7" " 01120001 03" "01120001" "TR7" " 01120001 05" "01120001" "TR7" " 01120002 02" "01120002" "TR7" " 01120002 03" "01120002" "TR7" " 01120003 02" "01120003" "TR7" " 01120004 02" "01120004" "TR7" " 01120006 02" "01120006" "TR7" " 01120006 03" "01120006" "TR7" " 01120007 02" "01120007" "TR7" " 01120007 03" "01120007" "TR7" " 01120007 05" "01120007" "TR7" " 01120009 01" "01120009" "TR7" " 01120009 03" "01120009" "TR7" " 01120011 02" "01120011" "TR7" " 01120012 02" "01120012" "TR7" " 01120014 02" "01120014" "TR7" " 01120015 02" "01120015" "TR7" " 01120015 03" "01120015" "TR7" " 01120015 04" "01120015" "TR7" " 01120015 05" "01120015" "TR7" " 01120016 02" "01120016" "TR7" " 01120018 02" "01120018" "TR7" end
Comment