The DHS Program User Forum: Egypt » Egypt DHS 2008

Home » Countries » Egypt » Egypt DHS 2008 - Merging EGIR5AFL and EGOD5AFL (Issues with merging )

Show: Today's Messages :: Show Polls :: Message Navigator

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

Report message to a moderator

[Message index]

		Egypt DHS 2008 - Merging EGIR5AFL and EGOD5AFL By: mariacedro on Tue, 22 March 2022 11:06
		Re: Egypt DHS 2008 - Merging EGIR5AFL and EGOD5AFL By: Bridgette-DHS on Wed, 23 March 2022 07:33
		Re: Egypt DHS 2008 - Merging EGIR5AFL and EGOD5AFL By: mariacedro on Wed, 23 March 2022 09:36

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Apr 25 02:11:08 Coordinated Universal Time 2024