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 )
Re: Egypt DHS 2008 - Merging EGIR5AFL and EGOD5AFL [message #24235 is a reply to message #24231] Wed, 23 March 2022 07:33 Go to previous messageGo to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3172
Registered: February 2013
Senior Member
Following is response from DHS Research & Data Analysis Director, Tom Pullum:

On page xxiii of the report you will find this paragraph: "The 2008 EDHS also collected information on a number of other health topics from 6,578 women and 5,430 men age 15-59 living in a subsample of one in four of the households sur[1]veyed. Among the key topics covered in these interviews were knowledge and awareness of avian influenza, HIV/AIDS and hepatitis C; pre[1]vious history of hypertension, cardiovascular illness diabetes and liver disease; attitudes and behavior with respect to female circumcision; health care costs; and health insurance coverage."

I did the merge with the lines given below. I reduced the respondents in the OD file to ever-married women age 15-49. Then, out of the 16,527 women in the IR file, I was able to find 4,181, almost exactly one in four, in the OD file. This is consistent with one fourth of the households being selected for the OD survey.

You merged with about 17% of women, rather than 25%, because you retained men, women age 50-59, and never-married women in the OD file. However, your merge was ok.

When users find a result like this, I recommend checking for subsampling on some of the key variables. Just go to the pdf of the final report and search for the word "subsample" and you will probably find the explanation.

cd e:\DHS\DHS_data\scratch

use "...EGIR5AFL.DTA", clear
keep v0*
gen cluster=v001
gen hh=v002
gen line=v003
gen in_IR=1
sort cluster hh line
save EGtemp.dta, replace

use "...EGOD5AFL.DTA", clear 
keep wline h* i*

* restrict to women
keep if h009==2

* restrict to ever-married
keep if i112<6

* restrict to age 15-49
keep if i111>=15 & i111<=59

gen cluster=hpsu
gen hh=hnumber
gen line=wline
gen in_OD=1
sort cluster hh line
merge cluster hh line using EGtemp.dta
tab _merge

replace in_IR=0 if in_IR==.
replace in_OD=0 if in_OD==.
tab in_*

 
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: Tue Oct 15 17:36:25 Coordinated Universal Time 2024