The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Penta1 to measles dropout (required urgent help)
Penta1 to measles dropout [message #24395] Sat, 07 May 2022 16:35 Go to next message
adis is currently offline  adis
Messages: 20
Registered: May 2022
We are exploring the 2019 mini Ethiopian DHS data set and we have created penta1 to measles dropout using formula in STATA. However, after generating the new var the, third category was created with a label of negative number. We cant figure out why that was happened? would you please help us solve this problem?

********the stata command we used was

gen penta1_ms_Drop= DPT1-ms

label define penta1_ms 0"Not dropped" 1"Dropped"
label val penta1_ms_Drop penta1_ms_Drop

what command should be used to overcome the negative number?

thank you for your swift response

[Updated on: Sat, 07 May 2022 16:39]

Report message to a moderator

Re: Penta1 to measles dropout [message #24403 is a reply to message #24395] Tue, 10 May 2022 10:23 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 737
Registered: April 2022
Senior Member
Janet-DHS wrote on Tue, 10 May 2022 10:22
Following is response from DHS Research & Data Analysis Director, Tom Pullum:

All the numbers in DHS reports are weighted by v005. Are you using weights? If you cannot match a number in a report, please tell us which number in which table in which report.

I have not worked with a DPT dropout variable before but I assume your DPT_dropout variable should would be calculated as follows:

gen DPT_dropout=0 if inrange(h3,1,3)==1
replace DPT_dropout=1 if DPT_dropout==0 & inrange(h,1,3)==0

I don't know what your "ms" variable is (it must be related to h9) but the logic would be the same. The dropout variable should be a binary variable that is conditional on having received DPT1, and it is NA (a dot in Stata) if the child did not receive DPT1. That is, it is NA if the did not receive DPT1, 0 if it received DPT1 but not DPT3, and 1 if it received DPT1 AND DPT3. That's what the two Stata lines would construct.

The woman is interviewed. In the KR file there is one record for each child born in the past five years. The file includes children who have died. The child's record includes most of the mother's variables, and there is hardly ever a reason to merge the KR and IR files.
Previous Topic: matching WHO weight/height scores to older surveys
Next Topic: How to do logistic regression for infant mortality
Goto Forum:

Current Time: Sun Jun 16 15:00:35 Coordinated Universal Time 2024