The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Merging data files » merging IR file with KR (Csection )
merging IR file with KR [message #16820] Wed, 06 March 2019 19:09 Go to previous message
mmbah is currently offline  mmbah
Messages: 8
Registered: March 2019
Dear Sir/ madam,

I wanted to calculate the total number of csection using the IR file for Malawi using the following commands:

use MWIR7HFL.dta

. gen csection=0

. replace csection=1 if m17_1==1 | m17_2==1 | m17_3==1 | m17_4==1 | m17_5==1 | m17_6==1
(976 real changes made)

tab csection

csection | Freq. Percent Cum.
0 | 23,586 96.03 96.03
1 | 976 3.97 100.00
Total | 24,562 100.00

However this is less than the total csection in the KR files

tab m17

delivery by |
caesarean |
section | Freq. Percent Cum.
no | 16,122 93.53 93.53
yes | 1,116 6.47 100.00
Total | 17,238 100.00

I tried to merge the IR and and the KR file so that I can use the m17 variable but loose lots of data in the merging process. I wanted someone to kindly help me calculated the total csection using the IR file or how to merge the m17 to the IR file


i calculate the number of stillbirths using the following commands:

gen stillbirths = regexm(vcal_1,"TPPPPPP")
label var stillbirths "stillbirths"

i obtained 213 stillbirths and the DHS final report indicated 236. Could someone help explained why and how to get the right values.

thanks for your kind help and understanding in advance

Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Merging all DHS recode files for one country in Stata
Next Topic: Merging IR and PR?
Goto Forum:

Current Time: Mon Jul 6 19:10:31 Eastern Daylight Time 2020