| Egypt DHS 2008 - Merging EGIR5AFL and EGOD5AFL [message #24231] |
Tue, 22 March 2022 11:06  |
mariacedro
Messages: 2
Registered: March 2022
|
Member |
|
|
Hello,
I am working with the 2008 Egypt DHS data, and I have to merge the dataset containing questions about AIDS and HIV (this is dataset EGOD5AFL) to EGIR5AFL, which contains information on circumcision, fertility and family planning. This is the STATA code I am using:
use "/Users/maria/Dropbox/Egypt DHS/Raw Data/Egypt DHS/2008/EGOD5ADT/EGOD5AFL.DTA", clear
rename hpsu v001
ren hnumber v002
ren wline v003
sort v001 v002 v003
merge 1:1 v001 v002 v003 using "/Users/maria/Dropbox/Egypt DHS/Raw Data/Egypt DHS/2008/EGIR5ADT/EGIR5AFL.DTA", force
tab _merge
However, using this code I get a pretty low matching rate, only equal to 17%.
Is there something I am getting wrong?
Thank you.
Best,
Maria
|
|
|
|
Members
Search
Help
Register
Login
Home
