The DHS Program User Forum      
Discussions regarding The DHS Program data and results
Home » Topics » Child Health » Child Health Indicators in Eastern African Countries
Child Health Indicators in Eastern African Countries [message #14404] Tue, 03 April 2018 21:56 Go to next message
funkyola is currently offline  funkyola
Messages: 5
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 #14454 is a reply to message #14404] Fri, 06 April 2018 19:58 Go to previous messageGo to next message
funkyola is currently offline  funkyola
Messages: 5
Registered: April 2018
Location: NIgeria
Member
Please I need response to my queries. Experts in the house, please respond. I need your clarifications.

thank you.
Re: Child Health Indicators in Eastern African Countries [message #14545 is a reply to message #14454] Fri, 20 April 2018 17:02 Go to previous messageGo to next message
Liz-DHS
Messages: 1264
Registered: February 2013
Senior Member
Dear User,
Your query has been forwarded to one of our experts and is in the queue. As soon as we have a response we will post. In the meantime, please refer to The Guide to DHS Statistics https:// dhsprogram.com/publications/publication-dhsg1-dhs-questionna ires-and-manuals.cfm for guidance and search the forum for similar posts. Many times you can find the guidance you need by searching the forum.
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 messageGo to next message
Trevor-DHS is currently offline  Trevor-DHS
Messages: 599
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:
gen b19 = v008 - b3

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 #14553 is a reply to message #14551] Sat, 21 April 2018 10:03 Go to previous messageGo to next message
funkyola is currently offline  funkyola
Messages: 5
Registered: April 2018
Location: NIgeria
Member
Thank you so much.
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 messageGo to next message
funkyola is currently offline  funkyola
Messages: 5
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 #14921 is a reply to message #14920] Tue, 15 May 2018 14:51 Go to previous messageGo to next message
funkyola is currently offline  funkyola
Messages: 5
Registered: April 2018
Location: NIgeria
Member
Thank you.
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
Liz-DHS
Messages: 1264
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


Previous Topic: Maternal Education in Child Recode File
Next Topic: calculating height for age for children in Ghana
Goto Forum:
  


Current Time: Mon Jul 23 01:42:00 Eastern Daylight Time 2018