| Ethiopia 2016 - Calculating First Postnatal Check-up [message #13410] |
Wed, 01 November 2017 23:14  |
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 #13486 is a reply to message #13464] |
Thu, 09 November 2017 07:31  |
Bridgette-DHS
Messages: 3214
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
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
