Hi everyone ,
I have difficulties to find the right command with conditions that make it possible to combine multiple responses of people in a dataset.

They were interviewed with the aim to find out at which age between 15 and 19 years* they did attend school and had a part time job at the same time. Therefore, only the observations are relevant, that show overlapping age ranges. This is the case with respondent 1359 and 1834.

Now I think I need a new Variable that can detect whether the part time work is within the school age range or not. People show up to 4 different episodes of occupation, meaning that some persnr are listed up to 4 times in the dataset.

These are my variables:


persnr ---spelltyp ------------agebegin------ageend
1359 -----school----------------15----------------17
1359 -----part time work------16----------------16
1679------part time work------15----------------16
1679----- school-----------------17---------------19
1834------school-----------------15---------------15
1834------part time work-------16---------------18
1834------school-----------------18---------------19

*I already excluded all other observations that are not between 15 and 19 years.


Do you have an idea for the right command?

Thanks a lot !