The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Egypt » Egypt DHS 2008 - Merging EGIR5AFL and EGOD5AFL (Issues with merging )
Egypt DHS 2008 - Merging EGIR5AFL and EGOD5AFL [message #24231] Tue, 22 March 2022 11:06 Go to previous message
mariacedro is currently offline  mariacedro
Messages: 2
Registered: March 2022

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.



Read Message
Read Message
Read Message
Previous Topic: Postnatal care in Egypt 2014 DHS
Next Topic: Egypt Women's Status 1995 Cluster Number
Goto Forum:

Current Time: Sun Oct 1 10:20:32 Coordinated Universal Time 2023