The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Malaria » How to create composite variables (Comparison of trends between DHS 2015 and DHS 2022)
Re: How to create composite variables [message #28889 is a reply to message #28882] Fri, 22 March 2024 16:06 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 878
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

It appears that you are using the HR file, which has one record for each household, rather than the PR file, which has one record for each person in the household. The subscripts _01, _02, etc., are the line numbers of individuals in the household, and if you switch to the PR file the line number is given with a separate variable, hvidx. I recommend using the PR file.

In the PR file for the 2022 survey, TZPR82 FL.dta, hml32 is the result of the malaria rapid test for each person. hml35 is in the data but in this survey it was not actually used. It is NA (coded with a dot) for each case. The other variable you mention, sb115, is not in the data at all.

In the PR file for the 2015-16 survey, TZPR7BFL.dta, hml32 is the result of the smear test and hml35 is the result of the rapid test. sb115 is also the result of the rapid test. I recommend that you ignore sb115. It simply duplicates hml35 but is reverse coded and does not apply to as many cases (see below). Let us know if you have other questions.

. correlate hml35 sb115

(obs=9,322)

 
             |    hml35    sb115
-------------+------------------
       hml35 |   1.0000
       sb115 |  -1.0000   1.0000

 
. tab hml35 sb115,m

 
result of |

   malaria |           result for malaria rdt

rapid test |  positive   negative      other          . |     Total
-----------+--------------------------------------------+----------
  negative |         0      8,206          0      1,348 |     9,554
  positive |     1,116          0          0        265 |     1,381
         . |         0          0          3     53,942 |    53,945
-----------+--------------------------------------------+----------
     Total |     1,116      8,206          3     55,555 |    64,880

 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Bednet coverage estimation issues
Next Topic: DHS and MIS data Kenya
Goto Forum:
  


Current Time: Sun Nov 3 07:47:53 Coordinated Universal Time 2024