The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Kenya » Anthropometric child measures KDHS 2014
Anthropometric child measures KDHS 2014 [message #12221] Wed, 12 April 2017 11:32 Go to next message
Josephine is currently offline  Josephine
Messages: 9
Registered: December 2016
Location: Sweden
Member
I am using the PR file to check stunting, wasting and underweight in children. I then use the commands below to replicate table 11.1. of the 2014 DHS.

keep if hc13==0
replace hc70=. if hc70>=9990
gen z=hc70/200
gen stunted=1 if z<-2
replace stunted =0 if z>-2 & hc70!=.
gen wght=hv005/1000000
bys hv025: tab stunt [iweight=wght]

However, I am not able to replicate the table results using the above commands. How do I get the correct figures?
Thank you.
Re: Anthropometric child measures KDHS 2014 [message #12238 is a reply to message #12221] Fri, 14 April 2017 07:58 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1485
Registered: February 2013
Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:


Please try the following. I have not tested it, but I would expect it to work. The main change is to divide hc70 by 100 rather than 200. Also there is no need to check hc13.


replace hc70=. if hc70>=9990
gen z=hc70/100
gen stunted=0 if z<.
replace stunted=1 if z<-2
gen wght=hv005/1000000
by hv025: tab stunt [iweight=wght]
Re: Anthropometric child measures KDHS 2014 [message #12239 is a reply to message #12238] Fri, 14 April 2017 08:23 Go to previous message
Josephine is currently offline  Josephine
Messages: 9
Registered: December 2016
Location: Sweden
Member
The new codes are able to replicate the results. Thank you very much.
Previous Topic: 2015 MIS Biomarker Data
Next Topic: 2014 Kenya long vs short-form questionnaire
Goto Forum:
  


Current Time: Sat Oct 20 22:17:12 Eastern Daylight Time 2018