The DHS Program User Forum
Discussions regarding The DHS Program data and results
Home » Data » Dataset use in Stata » Next Birth After Abortion (Identifying the birth order and date of birth after abortion)
Next Birth After Abortion [message #18659] Wed, 22 January 2020 08:46 Go to next message
dnameispaone is currently offline  dnameispaone
Messages: 19
Registered: February 2019
Member
Hi All,

I am using the women file from NFHS-4 India. I want to identify which is the next birth order after a woman had an abortion. Also, I want to know how many children does a woman had at the time of the abortion.

If I use the greater (>) or lesser (<) function with the date of abortion in the Stata command, it shortlists all the births before and after the abortion.


Any clue?

[Updated on: Wed, 22 January 2020 08:48]

Report message to a moderator

Re: Next Birth After Abortion [message #18706 is a reply to message #18659] Fri, 31 January 2020 15:52 Go to previous message
Courtney-DHS is currently offline  Courtney-DHS
Messages: 6
Registered: June 2018
Location: Rockville, Maryland
Member
Hello,

To estimate how many children a woman has at the time of abortion, here is the approach I would use in the BR file:

Check to if children pass 1 of 2 conditions:
1) If a woman has had an abortion (s234==3), look to see which births came before the date of the abortion (b3<v231) and make sure that child is alive (b5==1)
2) If the child is not alive (b5==0), check to see if the date the child died was after the abortion. To find this you could add the estimated age in months at death to the cmc date of birth, b7 + b3, and see if that is more than the date of abortion.

- I would then sum the children who passed these conditions and collapse the dataset by women.



There may be many ways to do this, but I think this approach would likely work.
I hope this helps and please post a response if you have any questions or to share your solution with others!
Previous Topic: duplicated almost blank variables
Next Topic: Quetions about calculating stunting rates in Stata
Goto Forum:
  


Current Time: Tue Nov 5 15:28:09 Coordinated Universal Time 2024