Dear Statalisters,

I have data following movements of cyclists through designated checkpoints. Each observation tracks one movement, listing the ID of the cyclist, ID of the checkpoint the cyclist passed through and the time when it happened. If a cyclist passed through more checkpoints, each passing would be recorded as a single observation.
Code:
* Example generated by -dataex-. To install: ssc install dataex
clear
input byte cyclist_id str checkpoint_id double time
1 "A" 1847001643859
2 "A" 1847001728656
3 "A" 1847002036732
4 "A" 1847002106261
1 "B" 1847002179608
2 "B" 1847002537078
3 "B" 1847002604183
4 "B" 1847002870569
1 "C" 1847003076879
2 "C" 1847003329085
3 "C" 1847003001583
4 "C" 1847003235132
end
format %tc_DD-Mon-YY_HH:MM:SS.sss time
I would like to trek a certain route the cyclists can take - from the checkpoint A via the checkpoint B to the checkpoint C. Specifically, I want to calculate the share of movements through the checkpoint A that afterwards in less than 10 minutes continued through the checkpoint B and then in less than next 10 minutes passed through the checkpoint C.

Do you have any advice?

Thank you,

Paulina