Tuesday, December 8, 2020

Drop Observations trough Waves

Hello 😊
I have the following variables over 3 waves:
Mergeid, retired(dummy: 1=retired 0=employed) and wave.
I want to say: drop the observation when a person comes out of retirement and become an employee.
I tried the following code, but failed.
by numid: drop if (((wave==1) & (retired==1)) & ((wave==2) & (retired==1)) & ((wave==3) & (retired==0)))
Can someone help me please? 😊

No comments:

Post a Comment