I'm having trouble writing a program to define the lower and upper bounds in order to run a bunch of models using interval censoring.
Here are some sample data and what I need to do:
id point time
1 3 10:20
1 4 11:00
1 4 11:30
1 5 12:15
1 5 12:45
1 6 13:50
1 7 14:30
2 2 09:00
2 2 09:45
2 4 10:30
2 5 11:15
2 7 12:25
I want to run several models (which I don't need help with) looking at the time it takes for the points to change. Since we do not know the exact time, I want to use interval censoring. Therefore, my goal is the get the possible lower and upper time points for each change. The changes I want to look at are 2 to 3, 3 to 4, 4 to 5, 5 to 6, 6 to 7. I need the lower and upper possible time ranges for each of these changes. The time ranges will be the least possible time it took to change from 2 to 3 and the most possible time it took to change from 2 to 3 (in minutes).
So for ID 2, I know that the time falls somewhere between 09:45 and 10:30 (45 minutes). The bounds would then be 1-45.
I'm looking for a way to calculate the lower and upper bound for each point change.
Thanks in advance!
... View more