Hi All,

I am using the women file from the Demographic and Health Survey (NFHS-4) India. In that file, each observation/record represent a woman who was interviewed in that survey.
For each woman, there are records of up to 20 children born to a woman. For each birth, they have provided the date of birth. They have also provided the date of the abortion if a woman had an abortion.
I want to identify which is the next birth after a woman had an abortion. For example, if the first child was born on 25th Jan 2005, then she had an abortion on say 2007, then again she gave birth to three children in the year 2009, 2011 and 2014. How can I identify which is the next birth after 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?