The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Reproductive Health » Replicating Table 9.7: Timing of first postnatal checkup for the mother
Replicating Table 9.7: Timing of first postnatal checkup for the mother [message #12178] Wed, 05 April 2017 17:54 Go to next message
Mlue
Messages: 92
Registered: February 2017
Location: North West
Senior Member
Hi all,

Could someone please have look at the Stata code below and let me know what it is that I am doing wrong.

I'm trying to replicate Table 9.7 from the PDHS report of 2012-13.

I'm close but there's something that I'm not doing correctly.

Here's the Stata code


**	CANNOT REPLICATE TABLE 9.7 OF PDHS 2012-13

/*	Table 9.7 Timing of first postnatal checkup for the mother */

/*
	What aim I possibly doing wrong in the code below?
	
	The totals (4 246) are fine, but the percentages are off by one or two digits

*/

********************************************************************************

** WEIGHT VARIABLE
gen weight = v005/1000000

********************************************************************************

** SURVEY SET
gen psu =    v021
gen strata = v022
svyset psu [pw = weight], strata(strata)

********************************************************************************

** Postnatal care of mother

gen		time_mother = 7
replace time_mother = 1 if m51 <= 103
replace time_mother = 2 if m51 >=104 & m51 <=123
replace time_mother = 3 if m51 >=124 & m51 <=202
replace time_mother = 4 if m51 >=203 & m51 <=206
replace time_mother = 5 if m51 >=207 & m51 <=305
replace time_mother = 6 if m51 == 199 | m51 == 998 | m51 == 999
replace time_mother = . if bidx >1
label define time_mother 1"<4 hours" 2"4-23 hours" 3"1-2 days" 4"3-6 days" 5"7-41 days" 6"dnk/missing" 7"Never"
label var time_mother "Mother's timing for postnatal care"
label val time_mother time_mother

svy: tab v190 time_mother if v008-b3<24 & bidx == 1, percent format(%4.1f) row

/*
	Example:
	
	For "Less than 4 hours" I do not get 53.7% as in the reports, and there seems
	to be other errors in my code. Please assist...

*/

tab v190 time_mother if v008-b3<24 & bidx == 1 [iw = weight], missing
tab v190 time_mother if v008-b3<24 & bidx == 1 [iw = weight], nof row missing

***********************************

** POSTNATAL CARE (postnatal checkup for the mother within two days)

recode time_mother (0/3 = 1 "Yes") (else = 0 "No"), gen(PNC_mother)
label var PNC_mother "Postnatal checkup in the first two days after birth"
label val PNC_mother PNC_mother

********

// CHECK

svy: tab v190 PNC_mother if v008-b3<24 & bidx == 1, percent format(%4.1f) row
tab v190 PNC_mother if v008-b3<24 & bidx == 1 [iw = weight], nof row missing

/*
	Not matching Table 9.7 of PDHS 2012-13
*/

Re: Replicating Table 9.7: Timing of first postnatal checkup for the mother [message #27478 is a reply to message #12178] Sun, 20 August 2023 09:11 Go to previous messageGo to next message
GAURAV25 is currently offline  GAURAV25
Messages: 6
Registered: July 2023
Member
please check this link "https://www.dhsprogram.com/pubs/pdf/FRIND2/FRIND2.pdf" page no 301 and table no:8.11 in that I want to see the indicator of "Percentage seen within two days of birth".I want to match with this indicator so please tell me how to match it. please tell me the STATA code
Re: Replicating Table 9.7: Timing of first postnatal checkup for the mother [message #27507 is a reply to message #27478] Thu, 24 August 2023 14:00 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 658
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

I have prepared a Stata program (NFHS2_table_8pt11_postnatal_24Aug2023.txt, as a text file) that gets fairly close to table 8.11 in the NFHS-2 final report. It shows which variables are involved and the basic logic of working with variables that specify units (such as days, weeks, etc.) and numbers (the number of days, weeks, etc.). I don't know why it does not match the table, but I cannot put more time into it. Perhaps you or other users can tweak it.
Timing of first postnatal checkup for the mother and new born [message #28827 is a reply to message #12178] Fri, 15 March 2024 12:51 Go to previous messageGo to next message
kclakhara is currently offline  kclakhara
Messages: 26
Registered: June 2016
Location: New Delhi
Member
Dear Sir/Madam,

I am working on the maternal and child health indicators given in the India factsheet, NFHS-5. I am getting exact percentage from the table 8.22 and 8.23 but not getting exact number of following indicatior.

46. Mothers who received postnatal care from a doctor/nurse/LHV/ANM/midwife/other health personnel within 2 days of delivery (%)

49. Children who received postnatal care from a doctor/nurse/LHV/ANM/midwife/other health personnel within 2 days of delivery (%)

74. Children with fever or symptoms of ARI in the 2 weeks preceding the survey taken to a health facility or health provider (%)

Kindly help which variable and base used with certain condition to generate above said indicator given in the India NFHS-5 factsheet. It will be very helpful, if you provide do file.

With Regards,

Kailash



Kailash Chandra Lakhara
Re: Timing of first postnatal checkup for the mother and new born [message #28862 is a reply to message #28827] Tue, 19 March 2024 14:01 Go to previous messageGo to next message
Janet-DHS is currently offline  Janet-DHS
Messages: 658
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

In 2022 I wrote a Stata program that should construct tables 8.22 and 8.23 (see attachment). Let us know if it doesn't work or you still have problems.
Re: Timing of first postnatal checkup for the mother and new born [message #28881 is a reply to message #28862] Thu, 21 March 2024 13:15 Go to previous messageGo to next message
kclakhara is currently offline  kclakhara
Messages: 26
Registered: June 2016
Location: New Delhi
Member
Dear Madam,

Thanks for the reply.

The attached Stata program is helpful for the table 8.22 and 8.23 for India NFHS-5, but indicator definition and values are different in factsheet compare to India NFHS-5 report.

Requesting, kindly help to generate following indicators given in the India NFHS-5 factsheet.

The indicators are:
46. Mothers who received postnatal care from a doctor/nurse/LHV/ANM/midwife/other health personnel within 2 days of delivery (%)

49. Children who received postnatal care from a doctor/nurse/LHV/ANM/midwife/other health personnel within 2 days of delivery (%)

74. Children with fever or symptoms of ARI in the 2 weeks preceding the survey taken to a health facility or health provider (%)

With Regards,

Kailash



Kailash Chandra Lakhara
Re: Timing of first postnatal checkup for the mother and new born [message #28888 is a reply to message #28881] Fri, 22 March 2024 16:04 Go to previous message
Janet-DHS is currently offline  Janet-DHS
Messages: 658
Registered: April 2022
Senior Member
Following is a response from DHS staff member, Tom Pullum:

The numbers in the fact sheet are supposed to be extracted from tables in the final report. They should not require any additional programming.

For indicator 46, the relevant table in the final report is table 8.22, next-to-last column, rows for urban, rural, total. The three percentages in table 8.22 are 62.4%, 60.8%, and 61.2%. These differ from the percentages in the fact sheet, which are 84.6%, 75.4%, 78.0%. The program I posted will reproduce the numbers in table 8.22. I have no idea why the percentages in the fact sheet are different.

For indicator 46, the relevant table in the final report is table 8.24, next-to-last column, rows for urban, rural, total. The three percentages in table 8.24 are 86.7%, 79.6%, and 81.6%. The percentages in the fact sheet are 85.7%, 76.5%, 79.1%. The percentages in the fact sheet are different from those in the final report, but they are close.

Indicator 74 describes treatment for fever or symptoms of ARI. In the final report, table 9.7 refers to ARI and table 9.9 refers to fever. I do not see a combined table for fever OR ARI. In table 9.7, column 3, the percentages are 55.8%, 56.1%, and 56.1%. In table 9.9, column 3, the percentages are 81.3%, 79.1%, 79.6%. We can compare these with the percentages in the fact sheet, which are 72.7%, 67.8%, and 69.0%. The fact sheet is consistent with the final report in the sense that the %s for "fever or ARI" are in between those for fever and those for ARI (for example, 72.7% is between 55.8% and 81.3%).

Indicator 74 deviates from the normal requirement that indicators in the fact sheet should link back directly and explicitly to indicators in the final report. There should have been separate indicators or fever and ARI, especially since the report shows that children are much less likely to be treated or ARI than for fever.

DHS has had no funds to support followup on the India surveys for more than two years. In that time there have been far more questions about the NFHS-5 than about any other survey. If you still have questions, you could direct them to the implementing agency, IIPS.
Previous Topic: Regarding term pregnancy
Next Topic: Regarding term pregnancy
Goto Forum:
  


Current Time: Thu Mar 28 13:54:19 Coordinated Universal Time 2024