| Determining child's birth order [message #26757] |
Wed, 26 April 2023 11:34  |
jangels1
Messages: 4
Registered: February 2023
|
Member |
|
|
I'm working with the birth recode file of the Bangladesh 2017-18 survey and I'm trying to tabulate child's birth order by place of delivery (in other words: does place of delivery vary by birth order of the child?). If it's easier, this could be equally well represented by a tab of mother's parity and place of delivery.
This dataset seems not to contain the BORD variable, and bidx doesn't really serve my purpose because birth order is what I'm after. Is there a way to calculate birth order? Thanks!
|
|
|
|
| Re: Determining child's birth order [message #26766 is a reply to message #26757] |
Thu, 27 April 2023 07:57  |
Bridgette-DHS
Messages: 3199
Registered: February 2013
|
Senior Member |
|
|
Following is a response from Senior DHS staff member, Tom Pullum:
If you have bidx or bord, but not the other, you can use this algebraic relationship: bidx+bord=v201+1. For example, if a woman had 4 children (v201=4), the most recent birth (with bidx=1) will be the 4th birth (bord=1). That is, 1+4=4+1. You can get bord from bidx with bord=v201+1-bidx.
If you are trying to match "birth order" in some tables, what's tabulated is not really bord but another variable that takes account of multiple births. For example, in the BD 2017-18 final report, tables 9.15-9.18, birth order is constructed from bord as follows. (For this table the loop for "border" only needs to go from 1 to 5 but for other purposes it could go as far as the maximum value of v201 in the survey.)
* Birth order
* To match birth order in the tables, bord must be modified to include multiple births
gen border=.
forvalues ll=1/5 {
replace border=`ll' if (bord==`ll' & b0==0) | (bord==`ll'+1 & b0==2) | (bord==`ll'+2 & b0==3)
}
gen birth_order=1 if border==1
replace birth_order=2 if border>1
replace birth_order=3 if border>3
replace birth_order=4 if border>5
label variable birth_order "Birth order"
label define birth_order 1 "1" 2 "2-3" 3 "4-5" 4 "6+"
label values birth_order birth_order
|
|
|
|
|
|
The DHS Program User Forum
Members
Search
Help
Register
Login
Home
