| anaemia in children [message #24872] |
Sun, 24 July 2022 06:43  |
kclakhara
Messages: 30
Registered: June 2016
Location: New Delhi
|
Member |
|
|
Dear Sir/Madam,
I am not getting reported figures of "Table 10.12 Prevalence of anaemia in children" from the NFHS-5 raw data.
I used condition (SPSS) for the base number is:
sel if (hv103=1 and hc1>=6 and hc1<=59 and hc55=0) .
Variable used for Anaemia status:
recode hc57 (3=1) (2=2) (1=3) (4=4) (8=8) (9=9) (missing=9) into anamia.
var lab anamia 'Anaemia status'.
val lab anamia 1 'Mild' 2 'Moderate' 3 'Sever' 4 'Not anemic' 9 'Missing'.
Is there are any error in the syntax? Please suggest, how to get reported figures.
Regards,
Kailash
Kailash Chandra Lakhara
|
|
|
|
|
|
|
|
| Re: anaemia in children [message #25712 is a reply to message #25710] |
Wed, 30 November 2022 01:00  |
Sadhvi
Messages: 5
Registered: November 2022
|
Member |
|
|
Hi.
The following is the code in r that I am using.
hh_recode = read_sas("Path\\IAPR7BFL.SAS7BDAT")
# Here I am filtering out the children who slept in the household last night, and aged 6 to 59 months and have a non-NA value for the anaemia status - HC57
cleanedAneSubsetNfhs5 = hh_recode[hh_recode$HV103 == 1 & !is.na(hh_recode$HC1) & hh_recode$HC1 > 5 & hh_recode$HC1 < 60 & !is.na(hh_recode$HC57),]
#overall anaemia
weightedSample = sum(cleanedAneSubsetNfhs5$HV005)/ 1000000
#now filtering out the children who have mild, moderate or severe anaemia as given by the variable HC57.
WeightedAnChildren = sum(cleanedAneSubsetNfhs5$HV005[cleanedAneSubsetNfhs5$HC57 %in% c(1,2,3)]) / 1000000
anemiaPrevalence = WeightedAnChildren/weightedSample
# Results: The total sample that turns out is 178952.3 but the number given in table 10.12 of the national report is 152,752. And the prevalence of anemia in children 6 to 59 months is 68.07%
[Updated on: Wed, 30 November 2022 01:01] Report message to a moderator |
|
|
|
| Re: anaemia in children [message #25716 is a reply to message #25712] |
Wed, 30 November 2022 12:06 |
Bridgette-DHS
Messages: 3199
Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS staff member, Tom Pullum:
I think there is some confusion about which NFHS we are talking about. I believe the original question was about the NFHS-4. The code I gave, when run for IAPR74FL.dta, matches the n in table 10.12 of the NFHS-4 report--205,035. It also matches the percentages in that table.
You must be talking about NFHS-5. I made a mistake when I referred to NFHS-5 on Nov. 29, because I had actually only applied the code to the NFHS-4 data. When I now apply the same code to the NFHS-5 data, IAPR7DFL.dta, I get the same n as you: 178,952, whereas the n in the report is 152,752.
In general, the design, tabulation plan, and computer code for the NFHS-4 and NFHS-5 are identical.
I have just looked at the CSPro code for this table in the NFHS-5. It includes the restrictions on hv103 and hc1. It does include a restriction to hc55=0, which was not needed to match the table for the NFHS-4. That gets the n down to 178,858. There are no other restrictions. To match 152,752 we would have to drop nearly 26 thousand children. I have no idea how to do this.
This is one of several tables that I cannot match in the NFHS-5 final report. I personally believe that the table in the report is incorrect. Perhaps other users can suggest a good reason why approximately 26,000 valid measurements of children's anemia in the household survey were omitted from table 10.12.
|
|
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
