The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » anaemia in children (Hot to get prevalence of anaemia in children)
anaemia in children [message #24872] Sun, 24 July 2022 06:43 Go to next message
kclakhara is currently offline  kclakhara
Messages: 26
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 #25702 is a reply to message #24872] Mon, 28 November 2022 12:14 Go to previous messageGo to next message
Sadhvi is currently offline  Sadhvi
Messages: 3
Registered: November 2022
Member
Same here. I am not getting the reported figures too.
I am getting it as 68.1 instead of 67.1%.

Any help would be greatly appreciated.
Re: anaemia in children [message #25710 is a reply to message #25702] Tue, 29 November 2022 08:45 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
Registered: February 2013
Senior Member
Following is a response from Senior DHS staff member, Tom Pullum:

The Stata code below matches the bottom ("Total") row of table 10.12 in the NFHS-5 report, including the percentages and the n. It is not necessary to include hc55 in the recode.

tab hc57 if hv103==1 & hc1>=6 & hc1<=59 [iweight=hv005/1000000]
gen     any_anemia=0 if hv103==1 & hc1>=6 & hc1<=59 & hc57<=4
replace any_anemia=1 if hv103==1 & hc1>=6 & hc1<=59 & hc57<=3
tab any_anemia [iweight=hv005/1000000]
Re: anaemia in children [message #25712 is a reply to message #25710] Wed, 30 November 2022 01:00 Go to previous messageGo to next message
Sadhvi is currently offline  Sadhvi
Messages: 3
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 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 3016
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.
Re: anaemia in children [message #25732 is a reply to message #25716] Fri, 02 December 2022 00:26 Go to previous message
Sadhvi is currently offline  Sadhvi
Messages: 3
Registered: November 2022
Member
Thank you Bridgette for your support and thank you Tom Pullum for confirming my doubts.
Previous Topic: Cancer screening
Next Topic: Telangana State discrepancy in numbers of women with a live birth
Goto Forum:
  


Current Time: Thu Mar 28 09:33:38 Coordinated Universal Time 2024