Home » Countries » Other countries » Any Anaemia Ghana DHS 2022 (I got a different value)
| Re: Any Anaemia Ghana DHS 2022 [message #30701 is a reply to message #30663] |
Tue, 21 January 2025 15:59   |
Janet-DHS
Messages: 932
Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member, Tom Pullum:
Biomarkers such as anemia, which is based on blood tests conducted on children during the household survey, can be found in both the PR and KR files. It is not always which file was used to construct a table.
You are apparently trying to match table 11.7 in the final report on the Ghana 2008 survey. It appears that this table was constructed with the KR file, because it contains the total of 2313 children age 6-59 months, but I see that there is indeed a problem with this table. Using the KR file (GHKR5AFL.dta), the following command should give the bottom row of the table, except for "any", which is obtained by adding up "severe", "moderate", and "mild":
tab hw57 if hw1>=6 [iweight=v005/1000000]
. tab hw57 if hw1>=6 [iweight=v005/1000000]
anemia |
level | Freq. Percent Cum.
------------+-----------------------------------
severe | 164.444313 7.11 7.11
moderate | 1,016.7676 43.95 51.06
mild | 478.457266 20.68 71.74
not anemic | 456.775979 19.74 91.49
9 | 196.975826 8.51 100.00
------------+-----------------------------------
Total | 2,313.421 100.00
Comparing with the bottom row of Table 11.9, this matches the total frequency, 2313. However, the percentages in the "mild", "moderate", and "severe" categories are a little too low and there are 197 (weighted) cases with the illegal code "9".
The other panels of the table should be obtained by inserting covariates after "tab". For example, the urban/rural panel should be obtained with
tab v025 hw57 if hw1>=6 [iweight=v005/1000000], row
Unfortunately, all the panels are a little off, in terms of both frequencies and percentages.
I believe that something was done behind the scenes, or outside of the KR file, to re-assign those 197 cases (the unweighted number is 193) in terms of values on the covariates as well as anemia category. I could pursue that hypothesis, but I just don't think it's worth the time.
Next, I believe that your more immediate interest is in the 2022 survey, and I think you want to match Table 11.12 in the final report on that survey.
I tried to match it with the KR file, but it turns out that the 2022 version of the anemia table comes from the PR file (GHPR8CFL.dta). You can match the bottom row of this table, except for the "any" column, with this command:
tab hc57 if hc1>=6 & hc1<=59 & hv103==1 [iweight=hv005/1000000]
tab hv025 hc57 if hc1>=6 & hc1<=59 & hv103==1 [iweight=hv005/1000000], row |
|
|
|
Current Time: Thu Jan 23 21:43:55 Coordinated Universal Time 2025
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
