The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Countries » India » Calculation of OOPE for delivery care using NFHS-4 , India data
Calculation of OOPE for delivery care using NFHS-4 , India data Mon, 19 March 2018 08:06
 jpp_pradhan Messages: 2Registered: March 2018 Location: Odisha, India Member
Dear Sir,

Greetings!!

I was planning to estimate OOPE for delivery care at the national and state level. Following steps, I have followed to estimate the same. However, the results are not matching with the figure given in the report (Table 8.20).

step 1: SELECT IF midx=1 & facility=1 (institutional delivery). [N=149770: matching with the report]

Step 2: Selected valid cases for the analysis.

compute valid=0.
if (s448aa=99998 & s448ba =99998 & s448bb=99998 & s448bc=99998 & s448bd=99998 & s449=99998) valid=1. If valid=0, considered for the analysis.

Step 3: computed delivery cost using the following syntax.

recode s448aa s448ba s448bb s448bc s448bd s449 (99998=0).

recode s448aa s448ba s448bb s448bc s448bd s449 (sysmis=0).

compute deliverycost= (s448aa+ s448ba+ s448bb+ s448bc+ s448bd+ s449).

Step 4: Estimated the mean OOPE

deliverycost
valid Mean N Std. Deviation
.00 8430.3232 144942 19334.84727
1.00 .0000 4828 .00000
Total 8158.5767 149770 19078.86061

for the valid cases (N=144942), the mean OOPE is: Rs 8430.

However, in Table 8.20 of India report, the mean OOPE is Rs. 7938.

Kindly advised how to match this figure.

Thank you and look forward to your kind response.

Warm regards,
Jalandhar

Associate Professor, Economics
Re: Calculation of OOPE for delivery care using NFHS-4 , India data [message #14300 is a reply to message #14288] Tue, 20 March 2018 13:53
 Hanna-DHS Messages: 1Registered: March 2018 Member
From Data Processing Specialist, Hanna Useem:

Dear Jalandhar,
In Table 8.20, the calculation to estimate OOPE for delivery care does not include transport, S448AA. It is calculated by S448BA (hospital stay), S448BB (tests), S448BC (medicines), and S448BD (other).

Best,

Hanna

Re: Calculation of OOPE for delivery care using NFHS-4 , India data [message #26523 is a reply to message #14300] Wed, 29 March 2023 07:33
 Lily Messages: 7Registered: December 2022 Member
As said above the calculation to estimate OOPE for delivery care does not include transport, S448AA but the footnote at table 8.20 in nfhs 4 report clearly mentions "Out-of-pocket cost paid for the delivery includes the cost of transportation, the hospital stay, tests, medicines, and other costs "
I simply tried to match the reports and excluding transportation, the mean OOPE :
Public facility=3130.621
Private facility =16513.15
Any facility=7706.62
N= 149768
And including the transportation variable,values are:
Public facility=3508.1
Private facility =17528.12
Any facility=8297.631
N= 149768
In either way , the values doesn't match the Nfhs 4 Report :
Public facility=3197
Private facility =16522
Any facility=7935
N= 149768
I used similar codes as mentioned in this thread:
https://userforum.dhsprogram.com/index.php?t=tree&th=123 20&goto=25945&#msg_25945
However I couldn't match values in any way for both NFHS 4 and NFHS 5. Any suggestions w.r.t. this will be of great help.Thank you in advance.
Re: Calculation of OOPE for delivery care using NFHS-4 , India data [message #26525 is a reply to message #26523] Wed, 29 March 2023 07:48
 Lily Messages: 7Registered: December 2022 Member
I have attached codes to this post which I used and was shared by DHS forum members in the earlier thread.
Home » Topics » Reproductive Health » Out of pocket expenditure per delivery calculation

[Updated on: Wed, 29 March 2023 07:51]

Report message to a moderator

Re: Calculation of OOPE for delivery care using NFHS-4 , India data [message #26528 is a reply to message #26525] Wed, 29 March 2023 09:04
 Bridgette-DHS Messages: 3130Registered: February 2013 Senior Member

Following is a response from Senior DHS staff member, Tom Pullum:

Hi Lily--Thanks very much for posting this. However, the program I posted yesterday (NFHS5_table_8pt20_KR_28Mar2023.txt) was almost exactly just a re-titled copy of that 12Jan2023 program. The main change, apart from the title, is that I inserted a corrected calculation of the birth order of the child. The calculation of birth order in the 12Jan2023 version did not match the table, but the 28Mar2023 version does match that. There were no changes to the calculation of OOPE.

Again, if anyone can match the OOPE numbers in table 8.20 in either the NFHS-4 or -5 reports, please let us know.
Re: Calculation of OOPE for delivery care using NFHS-4 , India data [message #27630 is a reply to message #26525] Wed, 13 September 2023 01:50
 anjalibansal6693 Messages: 24Registered: February 2018 Member
Hey Lily

Using the above code we are not able to match the Out of pocket expenditure for India, I have used the syntax and getting a difference of 500 rs, can you help with that

gen Delivecost = s454 if inrange(s454,0,99995)
foreach var of varlist s452a s452b s452c s452d {
gen `var'_new = `var' if inrange(`var',1,99990)
}
egen cost_other = rowtotal( s452a_new s452b_new s452c_new s452d_new)
replace cost_other=. if s452a_new==. & s452b_new==. & s452c_new==. & s452d_new==.
gen s451_new = s451 if inrange( s451 ,1,99990)
egen total_cost = rowtotal( Delivecost cost_other s451_new)
replace total_cost = . if Delivecost==. & cost_other==. & s451_new==.
ta total_cost if bidx==1
 Previous Topic: Family Structure Next Topic: Prevalence Ratio or Odds Ratio
Goto Forum:

Current Time: Tue Aug 13 11:13:11 Coordinated Universal Time 2024