child immunization [message #24386] |
Thu, 05 May 2022 15:46 |
adis
Messages: 20 Registered: May 2022
|
Member |
|
|
We are trying to analyze the child immunization to explore the determinants of Pentavalent and Measles dropout using Ethiopian 2019 mini DHS. We have used b19 (current age of child in months) and the target age group is from 12 to 23 months.The total number we got and the number in the report somehow differ. Would you please help us manage the problem?
How can we make the drop out rate calculation in stata?
we just tried in the following way
********for Penta and Measles dropout*****Dependent variable********
gen DPT_1 = inrange(h3,1,3)
gen DPT_2 = inrange(h5,1,3)
gen DPT_3 = inrange(h7,1,3)
gen DPT_dropout= DPT_1-DPT_3
gen ms_dropout = DPT_1-ms
gen Penta_drop_rate= (DPT_1-DPT_3/DPT_1)*100
gen ms_drop_rate= (DPT_1-ms/DPT_1)*100
************dropout is a binary variable for both Pentavalent and Measles
we have also come up with different number of children in the individual record and the child re-code data set. Even though the target group is children; we thought that it was the women who was interviewed. so please would you mind if you make this things clear?
since we will use few variables from individual re-code and some other from child re-code; how do we merge this two data sets. or is that possible to use child re-code data set for all maternal characteristics?
thank you in advance for your swift response
[Updated on: Sat, 07 May 2022 05:06] Report message to a moderator
|
|
|
Re: child immunization [message #24402 is a reply to message #24386] |
Tue, 10 May 2022 10:22 |
Janet-DHS
Messages: 880 Registered: April 2022
|
Senior Member |
|
|
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.
|
|
|
|
|
|
|
|
|
|
|
|
Re: child immunization [message #24591 is a reply to message #24583] |
Sat, 04 June 2022 15:59 |
adis
Messages: 20 Registered: May 2022
|
Member |
|
|
Thank you Janet and Shireen for your continuous support and assistance
We have two more questions
** We are confused how to exclude the unvaccinated children from the analysis (because our aim is to calculate the number of children drop out/not drop out and also calculating the dropout rate)
According WHO and Ethiopia EPI guideline
The percentage of children aged 12-23 months who dropped out from pentavalent and measles vaccination can be calculated by
(1) Subtracting the third dose of pentavalent vaccine from the first dose of pentavalent vaccine, (The difference between DPT1-DPT3)
(2) (2) subtracting the first dose of measles vaccine from the first dose pentavalent vaccine (the difference between DPT1 Measles1)
(3) Dropout rate could be calculated using
I. Penta = (dpt1- dpt3)/dpt1*100
II. Measles= (dpt1-Measles)/dpt1*100
We faced the following challenge
For calculating the drop outs or dropout rate; we have to exclude the number of unvaccinated children . However: when we try to do that using the following stata command ; the total number of children in the data set decreases and becomes equal for all (DPT1,DPT2 and Measles) (it becomes 587 for all)
(When we try to drop the unvaccinated children from dpt1 and dpt3 separately; the sample size drops)
Stata command: Drop if dpt1==0 & drop if dpt3==0 & drop if measlea==0
What should be the command?
The other challenge was the difference in sample size
In EDHS 2019 report, the sample size for children aged 12 to 23 months was 1028. In our data set we get 1008 using the following stata code. We couldn't figure out where the 20 children are lost? Would you please help us address this problem
Stata command used;
Child_age = 12-23 months old
gen months = b19
keep if b5 == 1 & months >= 12 & months <=23
Thanks
[Updated on: Sat, 04 June 2022 16:04] Report message to a moderator
|
|
|
|
|
|
|
Re: child immunization [message #24597 is a reply to message #24596] |
Mon, 06 June 2022 12:29 |
Shireen-DHS
Messages: 140 Registered: August 2020 Location: USA
|
Senior Member |
|
|
Hello,
Yes you cannot destring the caseid because it contains spaces (i.e. characters).
The case ID is made up of v001 , v002, and v003. See the attached file which is a screenshot of your data before dropping any children and after sorting as follows:
sort v001 v002 v003
br caseid v001 v002 v003 b16 b5
As you can see in the highlighted rows, these are three children with the same mother (v003=2) and in the same household (v002=73). b16 is the child's line number which is missing for one child because they are not living.
So a unique ID for the child should include v001, v002, and b16.
You can learn more about this in the Guide to DHS Statistics, Analyzing Data section, Matching and Merging Datasets subsection: https://www.dhsprogram.com/Data/Guide-to-DHS-Statistics/inde x.htm#t=Analyzing_DHS_Data.htm%23Matching_and_Mergingbc-7&am p;rhtocid=_4_4_6
Hope this helps.
Best,
Shireen Assaf
The DHS Program
|
|
|
|
|
|
Re: child immunization [message #24610 is a reply to message #24599] |
Tue, 07 June 2022 14:46 |
adis
Messages: 20 Registered: May 2022
|
Member |
|
|
Dear shireen,
After selecting the appropriate age group and excluding died children; we have to also exclude the unvaaccinated children from our data set.
But we failed to exclude these unvaccinated children from the data set?
we tried to do the exclusion after sorting the vars but it wasn't worked?
So what do you advise us?
[Updated on: Tue, 07 June 2022 14:48] Report message to a moderator
|
|
|
|
Re: child immunization [message #24616 is a reply to message #24611] |
Wed, 08 June 2022 11:13 |
adis
Messages: 20 Registered: May 2022
|
Member |
|
|
Thank you shireen
we actually checked the information you gave us on June 6.
From the definition of our dropout : there are dropout and dropout rates
to know the number of children drop out from the Vaccination we either use the difference between (Penta1 and Penta3) or (penta1 -Measles). When we do this, the expectation is those unvaccinated children shouldn't be part of the analysis. When we use rate/ratio; the previous formula you gave us worked but when it is simply the difference between the above mentioned vars the values reported are completely different.
I don't know where we made a mistake
I know we are taking your time but we really got interesting information that guides our analysis.
I hope you will have a finale say
Thanks
[Updated on: Wed, 08 June 2022 11:14] Report message to a moderator
|
|
|
|
|
|
|
|
Re: child immunization [message #29062 is a reply to message #29028] |
Thu, 18 April 2024 16:28 |
Janet-DHS
Messages: 880 Registered: April 2022
|
Senior Member |
|
|
Thank you for submitting your question. Could you please provide some more detailed information so we can better advise you?
Can you let us know:
• Which survey you are using (Include country name and year)?
• Which data files you are referring to?
• Which software you are using (Stata, SPSS, R, etc.)?
If you are trying to match a Table in a final report, please also indicate which table and which estimate you are trying to match.
|
|
|