Dear All,

I am working with longitudial survey and my dataset contains a data from the 7th Survey wave.
I am interested in the highest education level attained by the participant at the Point of time of 7th Survey wave. However, when I am working with the 7th wave, I only have the current education status variable.


I have an Access to the previous waves and participants id

How do I generate the highest education Level, given the data that I have from all previous survey vawes?

Example: In the Picture below, there are 1704 participants that pursue no education at the time of survey, but I do not know if they have no educataion at all, or they finished their education before this Survey wave.

Array


Thank you in Advance!