Hi everyone,

I have a panel dataset where I follow individuals for 12 waves (new_waves).
What I am trying to do is figure out the effect of education on the DV, but I need guidance as to how to capture this change.
So, for instance, the data below show just one respondent who was present in 7 waves and in wave number 9, this person attained a highschool diploma.
I have also eduw=3 which is a university degree.

My question is, how can I capture the before/after effect of the variable eduw on the DV for all individuals going from eduw=1 to eduw=2 and those from eduw=2 to eduw=3 regardless of the wave they are in? meaning that it doesn't matter if the individuals pass through educational levels in waves 1-5 or 6-12 or 1-12. What I am interested in is how going from low edu to high edu affects my DV.

Thanks in advance,



Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input byte new_wave long responseid byte eduw
 1 1006232 .
 2 1006232 .
 3 1006232 1
 4 1006232 .
 5 1006232 1
 6 1006232 .
 7 1006232 1
 8 1006232 1
 9 1006232 2
10 1006232 2
11 1006232 2
12 1006232 .
end
label values eduw eduw
label def eduw 1 "No completed education/Elementary school", modify
label def eduw 2 "Upper secondary education", modify
label def eduw 3 "University education", modify