Dear Stata users,
I am using an unbalanced panel dataset. Here is an example of my dataset.
hhid pid year attrition
1 1 2000 Successful
1 1 2001 Successful
1 . 2002 moved out of country
1 1 2003 Successful
2 2 2001 Successful
2 2 2002 Successful
hhid is household id, pid personal id. I only have information of survey attrition (if the interview was successful or not) at the household level. What I want to create is a variable that indicates me that the individual in the next year will "move out of the country", or that, in this case, the individual 1 in 2002 is not in the country. Beware that an individual can leave the country and return, and continue to participate in the survey in 2003 (but does not participate in the survey when it is out of the country). Could any one help me?
I am using Stata 14.