merging IR file with KR [message #16820] |
Wed, 06 March 2019 19:09 |
mmbah
Messages: 8 Registered: March 2019
|
Member |
|
|
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
secondly.....
i calculate the number of stillbirths using the following commands:
use MWIR7HFL
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
regards
Mamadou
|
|
|