Home » Topics » Reproductive Health » Pregnancy outcome (Factors associated with pregnancy outcome)
| Re: Pregnancy outcome [message #25212 is a reply to message #25153] |
Fri, 16 September 2022 16:59   |
Janet-DHS
Messages: 852
Registered: April 2022
|
Senior Member |
|
|
Following is a response from DHS staff member Tom Pullum:
You have to use the calendar. Rather than give an answer that's specific to this survey, I'll describe a strategy to develop an answer.
First, you need to find the code for "miscarriage". The codes for birth (B), abortion (A) and stillbirth (S) are the same in all surveys, but the code for miscarriage can vary. I go to the final report, find the woman's questionnaire, go to the beginning o Section 2, Reproduction. There are some instructions to the interviewer that include the code--it's C.
Second, you want to find WHICH (if any) of the vcal_* variables include the codes B, C, A, and S. At the end of this posting I will give Stata code to do this. PKIR71FL.dta includes 9 vcal variables. The program goes through all the columns in all of them. I look at the results and see that vcal_6 is the only one that includes B, C, A, and S. I see that vcal_1 includes B and T. T, for termination, is the aggregation of C, A, and S. In vcal_1 the letter T occurs 2930 times. In vcal_6, C occurs 2301 times, A occurs 252 times, and S occurs 377 times. The sum of these 3 numbers is 2930. So we have consistency.
It is common for vcal_1 to include B and T, and vcal_6 to include B and the breakdown of T. What I have described is an easy way to confirm this. I have just learned that in the NFHS-5, for example, the breakdown is given in vcal_7, BUT vcal_7 was omitted from the IR file! It will have to be included in the next issue of the IR file.
Third, I want to construct two variables using vcal_6. One is the cmc of the most recent pregnancy and the other is the outcome. I do that as follows. The following conversions are useful:
mbi: months given as months before interview: mbi=col-v018
cmc: months given in century month codes: cmc=v017+80-col
The most recent outcome that is B, C, A, or S will have the maximum value of cmc or the minimum value of mbi or the minimum value of col--they are all equivalent. Here is one approach.
use v001 v002 v003 v017 v018 vcal_6 using "C:\Users\26216\ICF\Analysis - Shared Resources\Data\DHSdata\PKIR71FL.DTA" , clear
* Use B M A S for birth, miscarriage, abortion, stillbirth
* In this survey, the code for miscarriage is C
gen str1 check="."
gen col_B=.
gen col_M=.
gen col_A=.
gen col_S=.
local li=1
quietly while `li'<=80 {
replace check=substr(vcal_6,`li',1)
replace col_B=`li' if check=="B" & col_B==.
replace col_M=`li' if check=="C" & col_M==.
replace col_A=`li' if check=="A" & col_A==.
replace col_S=`li' if check=="S" & col_S==.
local li=`li'+1
}
egen col_BMAS=rowmin(col_B col_M col_A col_S)
gen BMAS=.
replace BMAS=1 if col_BMAS==col_B & col_BMAS<.
replace BMAS=2 if col_BMAS==col_M & col_BMAS<.
replace BMAS=3 if col_BMAS==col_A & col_BMAS<.
replace BMAS=4 if col_BMAS==col_S & col_BMAS<.
* drop if the most recent outside the last 60 months
replace BMAS=. if col_BMAS-v018>60
label define BMAS 1 "Birth" 2 "Miscarriage" 3 "Abortion" 4 "Stillbirth"
label values BMAS BMAS
replace col_BMAS=. if col_BMAS-v018>60
gen cmc_BMAS=v017+80-col_BMAS
* BMAS is "." if there was no termination within the calendar
tab1 cmc_BMAS BMAS,m
keep v001 v002 v003 BMAS cmc_BMAS
sort v001 v002 v003
save temp.dta, replace
* merge this file back with the IR file
Here is the Stata program to find which codes are in which vcal variables. I have a path to a scratch folder but you can bypass that. I refer to the letters as "check".
cd e:\DHS\DHS_data\scratch
set more off
* open the IR file
use v001 v002 v003 vcal_* using "...PKIR71FL.DTA"
save temp.dta, replace
local lcol=1
while `lcol'<=9 {
scalar scol=`lcol'
use temp.dta, clear
local li=1
quietly while `li'<=80 {
gen str1 check_`li'="."
replace check_`li'=substr(vcal_`lcol',`li',1)
local li=`li'+1
}
reshape long check_, i(v001 v002 v003) j(column)
rename *_ *
scalar list scol
tab check,m
local lcol=`lcol'+1
}
|
|
|
|
Current Time: Mon Oct 7 02:17:22 Coordinated Universal Time 2024
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
