Hi!

I would like to calculate duration of low wage employment (dummy 0/1) for each individual in my data set.
My data is in long format, every personal identifier is repeated ten times, one for each year. Do any of you have any ideas of how to create a new variable that captures the duration of the spell/ if low wage emplyment lasts for all years in the data set/only a couple of years etc, by personal id? That is for the specific individual.

best,
Karin