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 Go to next message](/theme/default/images/down.png) |
Muneer Kalliyil
Messages: 13 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 #16239 is a reply to message #16237] |
Fri, 30 November 2018 21:37 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
Muneer Kalliyil
Messages: 13 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 #16262 is a reply to message #16259] |
Wed, 05 December 2018 11:30 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
fredarnold
Messages: 45 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 #16343 is a reply to message #16264] |
Tue, 18 December 2018 00:46 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
Muneer Kalliyil
Messages: 13 Registered: November 2018
|
Member |
|
|
Dear Fredarnold Sir,
First of all thank you so much for earlier clarification regarding mismatch in NFHS national report, Your solution was working perfectly.
However, now I have come across state-level reports. For example, I have taken the Jharkhand report. Table 61 of initial breastfeeding has been attached for your reference.
The table says that Number of last born children below 24 months is given as 4723.
However my estimation is not matching with state report, Stata coding is given below;
************************************************************ *******
****Jharkhand****
clear all
use "/Users/muneerkalliyil/Desktop/UNICEF/NFHS4/IAKR74FL.DTA"
gen survweight = v005/1000000
gen stratum = v023
svyset v021 [iw=survweight], strata(stratum)
gen age = v008 - b3
numlabel, add
****keeping only Jharkhand****
tab v024
keep if v024 == 15
****giving weight****
tabulate age if age < 24 & midx==1 [iw=survweight]
****without weight*****
tab age if age < 24 & midx==1
************************************************************ ********
I have estimated number of last born children below 24 months, giving weight and without giving as well.
Result says the number of children with weight = 2864, without weight = 4705.
Therefore, in both cases, the result is not matching with state report. It says the number is 4723. And the gap becomes large when we use weight.
My queries are;
Is it correct to use weight in the state level, if yes, is it different from national weight?
Why the gap is large with and without weight
Could you please sort out my problem as soon as possible
Looking forward to hearing from you
Thanks in advance
|
|
|
|
|
|
|
|
Re: Mismatch between National report and NFHS4 raw data analysis [message #16686 is a reply to message #16363] |
Sun, 17 February 2019 10:34 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
Pooja Arora
Messages: 3 Registered: February 2019
|
Member |
|
|
Dear fredarnold,
When I use svyset command with state level weights for doing state level analysis for India, I use the weight variable sv005. In that, does my strata remain the same? That is v022?
Thank you,
Pooja
fredarnold wrote on Wed, 26 December 2018 12:15It looks like you are trying to match the results for Jharkhand. In that case, you need to change the weight from v005 to sv005, which is necessary every time you are analyzing an individual state. As you can see below, the urban percentage for Jharkhand (29.9 percent) comes out exactly the same as the estimate in the Jharkhand state report.
. svy: tab bf1hour if age < 24 & midx == 1 & v102 == 1 & v024 == 15
(running tabulate on estimation sample)
Number of strata = 24 Number of obs = 852
Number of PSUs = 286 Population size = 881.91211
Design df = 262
-----------------------
RECODE of |
m34 (when |
child put |
to |
breast) | proportions
----------+------------
0 | .7011
1 | .2989
|
Total | 1
-----------------------
Key: proportions = cell proportions
[Updated on: Sun, 17 February 2019 10:37] Report message to a moderator
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Aug 19 00:37:38 Coordinated Universal Time 2024
|