Child Health Indicators in Eastern African Countries [message #14404] |
Tue, 03 April 2018 21:56 ![Go to next message Go to next message](/theme/default/images/down.png) |
funkyola
Messages: 8 Registered: April 2018 Location: NIgeria
|
Member |
|
|
Please, I need guide to generate DHS reported percentages of complete vaccination, postnatal care within 48 hours and exclusive breastfeeding in Ethiopia, Kenya, Tanzania and Malawi.
1. For vaccination I used the command below and replicated this for other vaccines of which what I got was slightly higher for all countries except Kenya. I used hw1 because b19 is not in Kenya dataset. How can I get accurate complete vaccination in the DHS reports?
gen bcg=0
replace bcg=1 if h2>0 & h2<8
replace bcg =. if hw1<12 | hw1>23 | b5==0
2. Which other variable will I combine with m71 to get percentage of children who received postnatal care within 48 hours after birth. I know m62 and m66 gives mothers postnatal check.
See below: recode m71 (100/202=1 "within 48 hours") (203/max=0 ">48 hours"), gen (postcheck)
tab postcheck [iw=wt]
3. Pls, how can I generate exclusive breastfeeding? Only Tanzania has the variable s469a.
Thank you.
|
|
|
|
|
Re: Child Health Indicators in Eastern African Countries [message #14551 is a reply to message #14545] |
Sat, 21 April 2018 02:42 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
Trevor-DHS
Messages: 802 Registered: January 2013
|
Senior Member |
|
|
1) For Kenya, hw1 only exists for the subset of the population for which anthropometry was collected. Instead of hw1, calculate b19 as follows:
and use b19 instead if hw1
2) Try the following code:
recode m71 (100/202=1 "within 48 hours") (203/max=0 ">48 hours or no check"), gen (postcheck)
* set to 0 if no checkup was performed
replace postcheck = 0 if m70 != 1
* restrict to births in the last 2 years, last births only, in the subsample for which the indicator is applicable
tab postcheck if v008 - b3 < 24 & midx==1 & v044 != . [iw=wt]
3) I don't have Stata code for this currently, but there are several other posts on exclusive breastfeeding on the forum, so I suggest searching those first.
[Updated on: Sat, 21 April 2018 02:42] Report message to a moderator
|
|
|
|
Re: Child Health Indicators in Eastern African Countries [message #14920 is a reply to message #14553] |
Tue, 15 May 2018 14:51 ![Go to previous message Go to previous message](/theme/default/images/up.png) ![Go to next message Go to next message](/theme/default/images/down.png) |
funkyola
Messages: 8 Registered: April 2018 Location: NIgeria
|
Member |
|
|
Please, I am yet to get accurate PNC within 2 days for newborn in Malawi, Ethiopia, Kenya and Tanzania.
To derive pnc timing, I used m71 for Kenya; combined m75 and m71 (Malawi, Tanzania and Ethiopia).
What I got is far from the reported rate on the country's report for the total number 'who received PNC' and 'those who received within 2 days'
I used the below to generate PNC
gen pnc=.
replace pnc=0 if m70==0|m74==0
replace pnc=1 if m70==1|m74==1
lab var pnc "pnc birth"
lab var pnc "pnc birth"
ta pnc [iw=wt]
ta pncb if hw1 < 24 [iw=wt]
also used the below to generate for "within 2 days"
recode m70 (0 8=0 "no") (1=1 "yes"), gen (m70_1)
recode m71 ( 998=9 "missing/DK" ) (100=1 "within 1 hour") (101/103=2 "1-3 hrs") (104/123=3 "4-23 hrs") (124/171 200/202=4 "1-2 days") ( 172/197 203/206=5 "3-6 days") (207/241 300/305=6 "7-41 days") ( 242/297 306/397=8 "checkup after 6 weeks"), gen(timeppcb)
recode m75 ( 998=9 "missing/DK" ) (100=1 "within 1 hour") (101/103=2 "1-3 hrs") (104/123=3 "4-23 hrs") (124/171 200/202=4 "1-2 days") ( 172/197 203/206=5 "3-6 days") (207/241 300/305=6 "7-41 days") ( 242/297 306/397=8 "checkup after 6 weeks"), gen(timeppcb2)
gen timeppc=0 if m70!=1 & m74!=1
replace timeppc=timeppcb if m70==1
replace timeppc=timeppcb2 if m74==1 & m70!=1
replace timeppc=9 if timeppc==.
label values timeppc timeppcb2
label var timeppc "time of first ppc checkup"
label define timeppcb2 0 "no checkup", add
PLS GUIDE ON HOW TO RECODE TO GET - Table 9.14 (Ethiopia); Table 9.11 (Malawi); Table 9.10 (Tanzania) and Table 9.9 (Kenya)
|
|
|
|
Re: Child Health Indicators in Eastern African Countries [message #14941 is a reply to message #14920] |
Thu, 17 May 2018 15:57 ![Go to previous message Go to previous message](/theme/default/images/up.png) |
Liz-DHS
Messages: 1516 Registered: February 2013
|
Senior Member |
|
|
A response by senior analyst, Dr. Lindsay Mallick:
Quote:
Dear user,
It seems like you are on the right track. The way we collected data on PNC changed between DHS-6 (when the Kenya survey was designed) and DHS-7 surveys. In DHS-6, we asked about PNC regardless of place of delivery. In DHS-7, we added a question to assess whether the mother or baby were checked prior to discharge if they delivered in a health facility. Therefore, different code is needed to replicate the table in Kenya than in Ethiopia, Malawi, and Tanzania. The indicator "Percentage of births with a postnatal check during the first 2 days after birth" also only includes PNC by a provider.
Another issue to note is that in for the 2014 Kenya DHS, we have a long and short questionnaire. Only a subsample of women was given the long questionnaire, which contained certain questions about PNC. In order to ascertain who was given these questions and ensure you have the right denominator, you need to merge in a variable from the PR file- hv027.
Finally, please note that DHS-7 questionnaires use the b19 variable for age in months of the child. See this page for more information: https://dhsprogram.com/data/calculating-the-age-of-children. cfm
The hw1 variable is used for the age of currently living children for the height and weight assessment. PNC is calculated for mothers who had a live birth, regardless of whether the child is currently living or not, so your denominators will not match.
Please see attached .do file to match the tables.
Lindsay
|
|
|