The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » Nigeria » Malaria (by microscopy) in Lagos State
Re: Malaria (by microscopy) in Lagos State [message #27313 is a reply to message #27260] Mon, 17 July 2023 12:15 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 938
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

I use Stata and am not referring to your R code. To get the tabulation it is only necessary to use the weights, not the full svyset command. I opened NGPR81FL.dta and entered the following Stata line:

tab hml32 if hv103==1 & hv024==36 & hc1>=6 & hc1<=59 [iweight=hv005/1000000]

You do not need to specify the value of hv042; it is 1 for all cases. The Stata line produces the following output:


final result of malaria from |

blood smear test | Freq. Percent Cum.

---------------------------------+-------------------------- ---------

negative | 338.41388 97.42 97.42

positive | 8.95048 2.58 100.00

---------------------------------+-------------------------- ---------

Total | 347.36436 100.00


This matches the weighted denominator of 347 and the proportion .026 in Table B.46 on page 147. That is, I match the report and do not get the numbers you got. Can you see where the difference is? Hope so. Good luck and thanks for using DHS data!
 
Read Message
Read Message
Previous Topic: NGHR7BFL
Next Topic: Nigeria MIS 2021 Ethics approval
Goto Forum:
  


Current Time: Tue Jul 15 03:02:29 Coordinated Universal Time 2025