The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Nutrition and Anthropometry » DHS India Differences in Reported and Generated Figures using KR & PR files (DHS 2019-21)
DHS India Differences in Reported and Generated Figures using KR & PR files (DHS 2019-21) [message #25332] Wed, 05 October 2022 14:47 Go to next message
marian is currently offline  marian
Messages: 13
Registered: August 2019
Member
Hi,

I have tried to match stata generates estimates with NFHS India reports.


Using PR file, the differences in both prevalence and number of children for all 3 anthropometric indicators is different for DHS 2019. The code is generating all other years of DHS correctly. Any way to generate prevalence using PR 2019-21 file correctly?

Using KR file, the prevalence rates for all 3 indicators is matching but the number of children in India report is different (DHS 2019-21). I just want to be sure why this is happening. Example given below


Using KR file for <60 months, number of children for WAZ

India report = 205,641
Generated= 205,551


Code used for KR file:

gen uw = .
replace uw = 1 if hw71<-200
replace uw = 0 if hw71 >-200 & hw71<9990

ta uw [iw=v005/1000000] if hw1 < 60


Please help

[Updated on: Wed, 05 October 2022 14:50]

Report message to a moderator

Re: DHS India Differences in Reported and Generated Figures using KR & PR files (DHS 2019-21) [message #25336 is a reply to message #25332] Thu, 06 October 2022 08:43 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 285
Registered: April 2022
Senior Member
Following is a response from DHS staff member Tom Pullum:

I will paste below Stata code to get the indicators from the KR and PR files. Basically just what you did, but it is not necessary to restrict on age. The relevant variables are NA (a dot) if the child is out of range.

I too do not match the n's in the report, but we almost never match the NFHS reports. Note that we are now on version D of the NFHS-5 data files. A more realistic goal would be to match STATcompiler, but even that is very difficult.

use "...IAKR7DFL.DTA", clear

gen haz=hw70/100 if hw70>-600 & hw70<600
gen waz=hw71/100 if hw71>-600 & hw71<500
gen whz=hw72/100 if hw72>-500 & hw72<500

gen stunted=0 if haz<.
replace stunted=1 if haz<-2

gen underweight=0 if waz<.
replace underweight=1 if waz<-2

gen overweight=0 if whz<.
replace overweight=1 if whz<. & whz>2

gen wasted=0 if whz<.
replace wasted=1 if whz<-2

tab1 stunted underweight overweight wasted [iweight=v005/1000000]


use "...IAPR7DFL.DTA", clear

gen haz=hc70/100 if hc70>-600 & hc70<600
gen waz=hc71/100 if hc71>-600 & hc71<500
gen whz=hc72/100 if hc72>-500 & hc72<500

gen stunted=0 if haz<.
replace stunted=1 if haz<-2

gen underweight=0 if waz<.
replace underweight=1 if waz<-2

gen overweight=0 if whz<.
replace overweight=1 if whz<. & whz>2

gen wasted=0 if whz<.
replace wasted=1 if whz<-2

tab1 stunted underweight overweight wasted [iweight=hv005/1000000]
Re: DHS India Differences in Reported and Generated Figures using KR & PR files (DHS 2019-21) [message #25337 is a reply to message #25336] Thu, 06 October 2022 14:16 Go to previous message
marian is currently offline  marian
Messages: 13
Registered: August 2019
Member
Thank you so much for your reply. I was really worried about getting a difference in sample figures despite the correct prevalence in NFHS-5 reports as I never faced this problem with previous rounds.

I also faced this problem with exclusive breastfeeding (EBF) under 6m status for DHS 2019-21. Please guide how the EBF status can be tabulated correctly for wasted/stunted children using PR or KR file given the sample reference (youngest child living with mother).

[Updated on: Thu, 06 October 2022 14:17]

Report message to a moderator

Previous Topic: Staple food by type in DHS nutrition surveys
Next Topic: Ghana DHS 2019 weight height
Goto Forum:
  


Current Time: Fri Feb 3 02:57:49 Coordinated Universal Time 2023