The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Discrepancy in stunting, wasting, underweight prevalence for Nepal DHS 2001
Re: Discrepancy in stunting, wasting, underweight prevalence for Nepal DHS 2001 [message #13588 is a reply to message #13587] Fri, 24 November 2017 03:51 Go to previous messageGo to previous message
dgodha
Messages: 44
Registered: November 2016
Location: India
Member
Hello,

I decided to try the Stata command 'zscore06' to get the aforementioned estimates. But here again, my estimates are not matching those in the DHS reports.

I understand that some discrepancy may be observed in case of DHS 2001 because the standards used would have been different but the same does not apply to the others. In case of Nepal 2016, the proportions are matching but not the frequencies while for the rest of the years (2011, 2006, and 2001) even the proportions are off by decimals or even the last digit. My commands are shown below:

* Calculate measurement date in days
gen mdate = mdy(hc18, hc17, hc19)
* Calculate birth date in days
gen bdate = mdy(hc30, hc16, hc31) if hc16 <= 31
replace bdate = mdy(hc30, 15, hc31) if hc16 > 31
* Calculate age in months with days expressed as decimals.
gen age = (mdate-bdate)/30.4375

//hw3 is height, clean DHS code and converts to cm
gen newh=hc3/10 if hc3!=9999
//hw3 is height in kg to one decimal w/o the decimal; convert to kg w/decimal; clean DHS code and
gen neww=hc2/10 if hc2!=999
* Compute Z-scores (In case of Nepal 2011 DHS, replace hc15=. if hc15==0)
zscore06, a(age) s(hc27) h(newh) w(neww) measure(hc15) male(1) female(2)

*Declaring Survey data
gen wt=hv005/1000000
svyset hv001 [pweight=wt], strata(hv022) vce(linearized) singleunit(missing) || hv002

*Completeness of information 
gen info=0
replace info=1 if hc33~=.

*Stunting
gen stunting=0 if hv103==1               
replace stunting=. if haz06>=6 
replace stunting=1 if haz06<-2 & hv103==1 
*Check with DHS report
svy:tab stunting if info==1

*Underweight
gen underwt=0 if hv103==1              
replace underwt=. if waz06>=6 
replace underwt=1 if waz06<-2 & hv103==1 
*Check with DHS report
svy:tab underwt if info==1

*Wasting
gen wasting=0 if hv103==1 
replace wasting=. if whz06>=6 
replace wasting=1 if whz06<-2 & hv103==1
*Check with DHS report
svy:tab wasting if info==1


I will appreciate advice on where I am going wrong or why the estimates do not match.
Thanks
Deepali


Deepali
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Missing data
Next Topic: Dealing with country-specific codes with panel data across 10 countries
Goto Forum:
  


Current Time: Mon Oct 21 16:51:38 Coordinated Universal Time 2024