The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » Mismatch between National report and NFHS4 raw data analysis
Mismatch between National report and NFHS4 raw data analysis [message #16227] Wed, 28 November 2018 21:40 Go to next message
Muneer Kalliyil is currently offline  Muneer Kalliyil
Messages: 6
Registered: November 2018
Member

I am working with NFHS4 raw data. Many times my analysis is not matching with National Report. Tried to sort out this issue, discussed with various people, but couldn't succeed. For example the number given in the national report of children born in the two years preceding the survey who ever breasted itself is greater than the total number of children which includes both who breastfed and not. How come that number will be greater than this total number. This is only one example, there are many other issues as well. I have used weights and all, followed every statistical procedure explained by USAID people.
Re: Mismatch between National report and NFHS4 raw data analysis [message #16237 is a reply to message #16227] Fri, 30 November 2018 11:48 Go to previous messageGo to next message
fredarnold is currently offline  fredarnold
Messages: 27
Registered: March 2014
Member
In Table 10.4 in the national report, the second column shows the number of children born in the last two years (97,989). that's the denominator of the estimate, not the numerator. As the table footnote indicates, that number includes births in the last two years whether the children are living or dead at the time of the interview.
Re: Mismatch between National report and NFHS4 raw data analysis [message #16239 is a reply to message #16237] Fri, 30 November 2018 21:37 Go to previous messageGo to next message
Muneer Kalliyil is currently offline  Muneer Kalliyil
Messages: 6
Registered: November 2018
Member
Dear sir
I am very gratitude andThanks for your response

If you are saying this number is (97,989) is the total number and the denominator, again it is not matching with our analysis, I have attached the stata code for the same, let me know whether I have made any mistakes.

These are my stata command used for


***********************************************************
clear all
use "/Users/muneerkalliyil/Desktop/UNICEF/NFHS4/IAKR74FL.DTA"

***APPLYING WEIGHTS************************

*Survey Weights

des v005
gen survweight = v005/1000000
gen stratum = v023
svyset v021 [iweight=survweight], strata(stratum)

****AFTER APPLYING WEIGHTS, JUST WE ARE LOOKING HOW MANY CHILDRENS ARE THERE BELOW 24 MONTHS,

**total number of children under 24 months
svy: tab hw1 if hw1 < 24
*******************************************************

The result says no of obs as 96782;

. svy: tab hw1 if hw1 < 24
(running tabulate on estimation sample)

Number of strata = 2513 Number of obs = 96782
Number of PSUs = 26472 Population size = 93053.216
Design df = 23959

NFHS4 National report gives the total number of children below 24 months as (97989), but our analysis shows as (96782 )


Please let me know, waiting for your reply

Regards
Muneer
Re: Mismatch between National report and NFHS4 raw data analysis [message #16246 is a reply to message #16239] Sun, 02 December 2018 17:42 Go to previous messageGo to next message
fredarnold is currently offline  fredarnold
Messages: 27
Registered: March 2014
Member
It looks like you're only including living children. As indicated earlier, the denominator includes both living and dead children who were born in the last two years.
Re: Mismatch between National report and NFHS4 raw data analysis [message #16247 is a reply to message #16239] Sun, 02 December 2018 22:53 Go to previous messageGo to next message
Muneer Kalliyil is currently offline  Muneer Kalliyil
Messages: 6
Registered: November 2018
Member
Dear Sir

Thanks for your reply

I will be very grateful if you could tell me how to include both living and dead children. As per my understanding, the variable hw1 (age in months) includes both, I have gone through all other variables in Children file, but couldn't get a variable differentiating between dead and alive children. Please let me know if you know how to include.


Looking forward to hearing from you
Thanks in advance
Re: Mismatch between National report and NFHS4 raw data analysis [message #16251 is a reply to message #16247] Mon, 03 December 2018 16:25 Go to previous messageGo to next message
fredarnold is currently offline  fredarnold
Messages: 27
Registered: March 2014
Member
You should use the kids' file (IAKR74). To obtain the number of children born in the two years before the survey (including both living and dead children), use V008 - B3 < 24.
Re: Mismatch between National report and NFHS4 raw data analysis [message #16254 is a reply to message #16251] Mon, 03 December 2018 22:36 Go to previous messageGo to next message
Muneer Kalliyil is currently offline  Muneer Kalliyil
Messages: 6
Registered: November 2018
Member
Dear Sir

very thankful to your replies

I tried using V008 - B3 < 24 for age, then I got the number of children below 24 as 101955. However, the national report says 95% of the total below 24 has been breastfed, if we take the 95% of this number (96857), again it is not matching with national report number (97989). Could you please let me know if I am making any mistakes

Looking forward to hearing from you
Regards
Re: Mismatch between National report and NFHS4 raw data analysis [message #16257 is a reply to message #16254] Tue, 04 December 2018 13:53 Go to previous messageGo to next message
fredarnold is currently offline  fredarnold
Messages: 27
Registered: March 2014
Member
You're using the unweighted data. You'll have to weight the data to match what's in the report. Once you weight the data, you should be able to match the total number of children born in the two years preceding the survey (97,989). As mentioned earlier, the number of children in the second column of Table 10.4 is the denominator (the total number of children born in the two years preceding the survey). It is not the numerator (the number of children born in the two years preceding the survey who were ever breastfed).
Re: Mismatch between National report and NFHS4 raw data analysis [message #16259 is a reply to message #16257] Tue, 04 December 2018 23:28 Go to previous messageGo to next message
Muneer Kalliyil is currently offline  Muneer Kalliyil
Messages: 6
Registered: November 2018
Member
Dear Sir,

I have already applied survweight, tried both pweight and iweight. The number which I told earlier is coming after applying the weight. Secondly, If the number in the second column is denominator, then our estimated denominator is definitely coming larger than the given denominator. As I told before, in our estimation, the total number of children below 24 months is coming around 101955. However, the given number in the report is only around 97989.

Please let me know if I am making any mistakes.

Looking forward to hearing from you

Thanks
Re: Mismatch between National report and NFHS4 raw data analysis [message #16262 is a reply to message #16259] Wed, 05 December 2018 11:30 Go to previous messageGo to next message
fredarnold is currently offline  fredarnold
Messages: 27
Registered: March 2014
Member
The Stata code below matches the denominator in the NFHS-4 report:

gen age = v008 b3
gen xweight = v005/1000000
tabulate age if age < 24 [iw=xweight]

age | Freq. Percent Cum.
------------+-----------------------------------
0 | 1,629.0776 1.66 1.66
1 | 3,670.6754 3.75 5.41
2 | 3,935.1411 4.02 9.42
3 | 4,126.8893 4.21 13.64
4 | 4,405.3671 4.50 18.13
5 | 4,464.9622 4.56 22.69
6 | 4,501.2567 4.59 27.28
7 | 4,415.1894 4.51 31.79
8 | 4,631.844 4.73 36.51
9 | 4,300.8026 4.39 40.90
10 | 4,114.4416 4.20 45.10
11 | 3,905.3321 3.99 49.09
12 | 4,205.2019 4.29 53.38
13 | 4,226.0275 4.31 57.69
14 | 4,074.5033 4.16 61.85
15 | 4,041.3627 4.12 65.97
16 | 4,252.8293 4.34 70.31
17 | 4,150.9773 4.24 74.55
18 | 4,489.1452 4.58 79.13
19 | 4,189.1484 4.28 83.41
20 | 4,192.2816 4.28 87.69
21 | 4,265.4102 4.35 92.04
22 | 4,003.8333 4.09 96.12
23 | 3,797.2187 3.88 100.00
------------+-----------------------------------
Total | 97,988.918 100.00
Re: Mismatch between National report and NFHS4 raw data analysis [message #16264 is a reply to message #16262] Wed, 05 December 2018 20:57 Go to previous message
Muneer Kalliyil is currently offline  Muneer Kalliyil
Messages: 6
Registered: November 2018
Member
Dear Fredarnold Sir,

Thank you so much, the code is working.

I was looking for this solution for many days.

Will keep in touch with

Regards
Muneer
Previous Topic: Maternal Mortality
Next Topic: Missing variable
Goto Forum:
  


Current Time: Sat Dec 15 07:26:24 Eastern Standard Time 2018