The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Reproductive Health » Ethiopia 2016 - Calculating First Postnatal Check-up
Ethiopia 2016 - Calculating First Postnatal Check-up [message #13410] Wed, 01 November 2017 23:14 Go to next message
unionman is currently offline  unionman
Messages: 3
Registered: October 2017
Member
Hi, I am attempting to reproduce table 9.12 in the 2016 EDHS, and am struggling to reach the correct figures. The figure I am trying to focus on is the Total Number of Women, which is listed as 4308.

I understand that this number is weighted, and because it is labeled as 'Number of Women', I have been using the Individual Records (IR), and have been summing weights of those who have had a birth in the last 23 months (V008 - B3$01 < 24) but I get a total of 4246 instead of the 4308. I have also tried using the Birth Records file, and taking the difference between V008 - B3, but I get 4396. Can someone point out where I am going wrong? I looked at the DHS guide to statistics, https://dhsprogram.com/pubs/pdf/DHSG1/Guide_to_DHS_Statistic s_29Oct2012_DHSG1.pdf, page 108, but I'm assuming that this formula is no longer accurate. Any help would be greatly appreciated, thanks!
Re: Ethiopia 2016 - Calculating First Postnatal Check-up [message #13462 is a reply to message #13410] Mon, 06 November 2017 11:29 Go to previous messageGo to next message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1482
Registered: February 2013
Senior Member

Following is a response from Senior DHS Stata Specialist, Tom Pullum:


The newest surveys, including the Ethiopia 2016 DHS, include day of birth, as well as month and year. This permits a more exact definition of "the past two years". The cdc (century day code) of the interview is v008a. The cdc of the birth of the most recent child is b18_01. The condition for being in table 9.12, that is, for a birth in the past two years, is v008a-b18_01<=730. The weighted number of births satisfying this condition is 4308.

Re: Ethiopia 2016 - Calculating First Postnatal Check-up [message #13464 is a reply to message #13462] Mon, 06 November 2017 21:15 Go to previous messageGo to next message
unionman is currently offline  unionman
Messages: 3
Registered: October 2017
Member
Thanks for the response! I would have thought that the proper comparison would have been V008A - B18_01 < 730, since we want less than 2 years.

Also, which variables should I be looking at for 1) mother's postnatal check 2) newborn's postnatal check? I could only find variable M71 for postnatal check timing for EDHS. Further, I was unable to produce the same percentage values as found in the EDHS final report using M71_01. Only 6.4% of values have responses for M71, which confuses me. Any assistance would be gladly appreciated!
Re: Ethiopia 2016 - Calculating First Postnatal Check-up [message #13486 is a reply to message #13464] Thu, 09 November 2017 07:31 Go to previous message
Bridgette-DHS is currently offline  Bridgette-DHS
Messages: 1482
Registered: February 2013
Senior Member
Following is another response from Senior DHS Stata Specialist, Tom Pullum:


Hi Toshi,

I will insert something from someone on our staff (Lindsay Mallick) who looked into this:

m70_1 (it's only 1 because we only ask for the most recent birth) asks about the timing of pnc for the baby. Typically, m51_1 or m51a_1 is the variable for pnc timing for the mother. However, in a handful of newer surveys, there are separate questions for pnc based on the place of delivery. So the variables would be m63_1 (health facility) or m67_1 (home birth). Looks like that's the case for Ethiopia.

One thing to note though, is that m67_1 also includes women who delivered in a facility but did not get a postnatal check before discharge. So this variable combines two questions on pnc timing after birth: one for women who delivered in a health facility but did not get a pnc check before discharge and one for timing of pnc for women who delivered at home. The variable label says "how long after discharge / delivery at home respondent health check took place". That is a little misleading because the questions in the questionnaire refer to timing after delivery.

I have tried to figure out how m63_1 and m67_1 are integrated to produce the distribution in table 12.2 (just working with the totals row). I can't quite get a match, so I am asking Lindsay to look at the actual code that was used by the data processing staff to construct table 12.2.

The attached do file (from Lindsay Mallick) constructs the variable. Note that the age of the child in completed months is given by b19, so you don't actually need to compare b18 with v008a.

After you run this, enter "tab newpnctime [iweight=wt]" and you will get the distribution in the totals row of table 9.12.

Cheers--Tom

Previous Topic: coding of elements in reproductive calendar
Next Topic: Filter in question #343
Goto Forum:
  


Current Time: Fri Oct 19 01:26:03 Eastern Daylight Time 2018