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  |
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
*/
|
|
|
|
|
|
|
|
| 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  |
kclakhara
Messages: 30
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 #28881 is a reply to message #28862] |
Thu, 21 March 2024 13:15 |
kclakhara
Messages: 30
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 |
Janet-DHS
Messages: 880
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.
|
|
|
|
| Re: Replicating Table 9.7: Timing of first postnatal checkup for the mother [message #29107 is a reply to message #12178] |
Wed, 24 April 2024 05:50 |
doria786
Messages: 1
Registered: April 2024
|
Member |
|
|
When it comes to generating the time_mother variable, your conditions for categorizing the timing of postnatal care appear to be logically structured. However, one potential issue could be with the use of the & operator without enclosing the conditions in parentheses. In Stata, logical conditions combined with & should be enclosed in parentheses to ensure they are evaluated correctly.
** WEIGHT VARIABLE
gen weight = v005/1000000
** SURVEY SET
gen psu = v021
gen strata = v022
svyset psu [pw = weight], strata(strata)
When it comes to generating the time_mother variable, your conditions for categorizing the timing of postnatal care appear to be logically structured. However, one potential issue could be with the use of the & operator without enclosing the conditions in parentheses. In Stata, logical conditions combined with & should be enclosed in parentheses to ensure they are evaluated correctly.
Additionally, the replace command for time_mother = . if bidx > 1 might be excluding some cases that should be included in the analysis. Make sure that this condition aligns with the methodology used in the PDHS report.
For the tabulation commands, it's crucial to ensure that the format(%4.1f) option is used consistently to match the report's percentage format. Also, check if the row option is necessary for your analysis, as it changes the way percentages are calculated. If you continue to face discrepancies, I recommend comparing your results with the PDHS report's methodology section or checking for any updates or errata related to Table 9.7. You can find the PDHS 2012-13 report here for reference.
|
|
|
|
Goto Forum:
Current Time: Wed Nov 13 04:15:03 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
