The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Topics » Reproductive Health » Place of delivery (Merging BR with IR file)
Place of delivery [message #22166] Tue, 09 February 2021 04:53 Go to next message
Sourav is currently offline  Sourav
Messages: 6
Registered: February 2021
Member
Hello,

Firstly,
I am using NFHS-4 IR file and there is Place of Delivery (Table 8.13) in report and this "place of delivery" is created with using BR file, so I want to merge that particular m15 variable of NFHS-4 BR file with NFHS-4 IR file, how can I do this?

Secondly,
In the report of NFHS-4, the N of "place of delivery" is 249967 whereas in BR file it is 249809 (putting weight) and remaining are missing which I have seen is SPSS software but in STATA the missing values are not showing in tabulate function of m15 variable, so how can I match the N of "Place of delivery" with the report using STATA?

Thank You.
Re: Place of delivery [message #22196 is a reply to message #22166] Wed, 10 February 2021 09:01 Go to previous messageGo to next message
Shireen-DHS is currently offline  Shireen-DHS
Messages: 140
Registered: August 2020
Location: USA
Senior Member
Hello Sourav,

First, you do not need to merge the BR and IR file. The variable m15 is in the BR file. To learn more about merging in case you need it, please go to Chapter 1 in the Guide to DHS Statistics: https://www.dhsprogram.com/Data/Guide-to-DHS-Statistics/inde x.htm#t=Analyzing_DHS_Data.htm

The code below will give you a match to Table 8.13. Notice you use a dot "." to get the missing.

I would like to note that in our standard code available on https://github.com/DHSProgram including code for this indicator in Chapter 9 in the RH_DEL.do file, we do not include a dot for the missing category. However, this table has included the systematic missing. If I do not include the dot I get the same N you have.

*generate age of child
gen age = v008 - b3

recode m15 (21/27=1 "Public sector") (33=2 "NGO/trust") (31/32=3 "Private sector") (11=4 "Own home") (13=5 "Parent's home") (12=6 "Other home") (96/99 . = 9 "Missing" ), gen(placedel)

*select for births in the last five years
replace placedel = . if age>=60
label var placedel "Live births by place of delivery"

gen wt=v005/1000000
tab placedel [iw=wt]


Thank you.

Best,

Shireen Assaf
The DHS Program
Re: Place of delivery [message #22198 is a reply to message #22196] Wed, 10 February 2021 10:28 Go to previous message
Sourav is currently offline  Sourav
Messages: 6
Registered: February 2021
Member
ok. Thank You very much.
Previous Topic: Discrepancy in population totals for postnatal checkup-India (NFHS 4)
Next Topic: Getting delivery indicators for disabled mothers
Goto Forum:
  


Current Time: Fri Mar 29 10:19:11 Coordinated Universal Time 2024