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? 😊