The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Egypt » Issue in child age variables in DHS08?
Issue in child age variables in DHS08? [message #3381] Tue, 02 December 2014 11:23 Go to previous message
Messages: 9
Registered: October 2013
Dear DHS,

I'm analyzing child feces disposal by child age in years.

I get the correct percentages for stool disposal, and the total number of children, of all under fives.

But the number of children in each year bracket (0-11 months, 12-23 months, etc) differs from your report. Is there an issue with variable B3 or v008?

In the same processing for other DHS surveys, everything matches fine.

My syntax:
use " DHS.STATA.datasets/ChildRecodeKR/EgyptDHS08.EGKR5AFL/EGKR5AD T/EGKR5AFL.DTA "
keep v001 v002 v003 bidx b9
tab bidx b9
*keep if child lives with respondent
keep if b9==0
collapse (min) bidx, by(v001 v002 v003)
sort v001 v002 v003 bidx
save "/Desktop/temp2.dta", replace
use " DHS.STATA.datasets/ChildRecodeKR/EgyptDHS08.EGKR5AFL/EGKR5AD T/EGKR5AFL.DTA "
keep bidx b3 h11 hw1 hw13 hw70 v001 v002 v003 v005 v008 v021 v022 v024 v025 v116 v160 v190 v440 v465 v026
sort v001 v002 v003 bidx
merge v001 v002 v003 bidx using "/Desktop/temp2.dta"
keep if _merge==3
drop _merge
tab bidx
gen stratid = v022
gen psu = v021
gen weight = v005/1000000
svyset psu [pw=weight], strata(stratid)
gen age_interval=0
*modify age_interval to age in years.
replace age_interval=1 if v008-b3>11
replace age_interval=2 if v008-b3>23
replace age_interval=3 if v008-b3>35
replace age_interval=4 if v008-b3>47
*to check against report
tab age_interval v465 [iweight=weight]

The output and relevant comparison section in your report, are attached in one excel file.

Thanks in advance for your response.

Read Message
Read Message
Read Message
Previous Topic: Spatial Join in QGIS 2.2
Next Topic: Egypt DHS 2014 - Standard
Goto Forum:

Current Time: Mon Dec 11 00:44:46 Coordinated Universal Time 2023