| Previous adverse pregnancy outcome variable [message #11834] |
Wed, 15 February 2017 22:02  |
chr8850
Messages: 20
Registered: July 2016
|
Member |
|
|
Hi there,
I am working with the Afghanistan 2010 AMS and using the women's data have generated a pregnancy file using reshape that contains a list of the mother's pregnancies in the last five years. Using the pregnancy history data I generated a pregnancy outcome variable to determine if the outcome was a live birth, stillbirth or miscarriage. What i would like to do it be able to is determine if prior to the mothers' most recent pregnancy (identified as those cases where idx==q402) whether she had any other adverse pregnancy outcomes. At the moment the file is in such a way that the pregnancies are listed from 1 to X with 1 being her first pregnancy. I'm not sure how much information you need, but below I'm pasting the code used for generating the pregnancy outcome variable and a caseid for each woman as there was not one in the file.
For case ID:
egen caseid =concat (qhclust qhnumber qline),f(%03.0f)
For pregnancy outcome variable:
gen pregoutcomeb = .
replace pregoutcomeb = 1 if q314== 1 // q314- baby born alive born dead (1=born alive, 2=born dead)
replace pregoutcomeb = 2 if pregoutcomeb == . & q314 ==2 & q325 >=7 & q325 <98 // q325- how many months did pregnancy last?
replace pregoutcomeb = 3 if pregoutcomeb == . & (q325 <7 | q325 >= 98) //
lab def pregoutcomeb 1 "Live birth" 2 "Stillbirth" 3 "Miscarriage"
lab val pregoutcomeb pregoutcomeb
lab var pregoutcomeb "Pregnancy outcome"
I have noted that the women's data file includes a variable "psurv" that refers to survival of the preceding pregnancy before the most recent pregnancy. However some of the cases don't exactly match the pregnancy outcome variable that I generated (for example there is a case classified as a stillbirth but when i looked at the question where the mother was asked if the baby was born alive born dead, she said born alive, so i have called that a live birth rather than a stillbirth) and this variable only has two outcomes - live births and stillbirths with miscarriages being classified as stillbirths from what i can see.
It would also be good to know how I can count how many of each outcome the mother has as well i.e for each mother how many Live births, stillbirths and miscarriages in a lifetime.
Any help you can provide would be much appreciated
best,
Ali
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
