The DHS Program User Forum: Dataset use in Stata

Home » Data » Dataset use in Stata » stunting calculation

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

stunting calculation [message #26417]

Sat, 18 March 2023 10:04

Manasa
Messages: 4
Registered: March 2023

Member

sir i have combined pr and kr data set of NFHS 5. however im not able to calculate statewise stunting and underweight percentage of children. How to approach it sir.

Report message to a moderator

Re: stunting calculation [message #26425 is a reply to message #26417]

Mon, 20 March 2023 09:20

Bridgette-DHS
Messages: 2801
Registered: February 2013

Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

You do not need to combine the PR and KR files for this purpose. You use one file or the other. In the PR file, the relevant variables are hc70-hc72. In the KR file they are hw70-hw72. If you use the PR file you get a few more children--those who are in the household but whose mother is NOT in the household. I will paste the Stata lines below, illustrating the "tabstat" command, which some users may not know about. You can run the same lines in the KR file by changing hc to hw.

use "...IAPR7DFL.DTA", clear

keep if hc1<.
gen haz=hc70 if hc70>=-600 & hc70<=600
gen waz=hc71 if hc71>=-600 & hc71<=500
gen whz=hc72 if hc72>=-500 & hc72<=500

gen stunted=0
replace stunted=100 if haz<-200

gen underweight=0
replace underweight=100 if waz<-200

gen overweight=0
replace overweight=100 if whz>200

gen wasted=0
replace wasted=100 if whz<-200

tabstat stunted underweight overweight wasted [fweight=hv005], statistics(mean) by(hv024) format(%6.1f)

Report message to a moderator

Previous Topic:	appending Jordan DHS 2007 2012 2017
Next Topic:	Jordan dataset

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun May 28 13:16:25 Coordinated Universal Time 2023