Hello!

I have a data set as shown below. I would like to only analyse the change in behaviour the year before person was widowed, and the year after the person was widowed and remains as a widow (i.e. not remarried in the 2nd consecutive year but can be remarried after 2 years of becoming a widow although after the 2 years, this will not be of interest to me).


The id below was only widowed for one recorded time period and was remarried in the next recorded time period and therefore, i will not be able to use an id like this.
Array

Therefore, how do I only keep variables whose marital status changes from married to widowed and remains as widowed for at least 2 consecutive years?

Thank you,
Sarah.