Hello, I am having trouble figuring out how to code for an outcome where the event begins the first time the variable measures below 70 and it continues until there are 60 minutes worth of measurements 70 or above (the measurements occur every five minutes). The event then ends and the person is eligible for a new event the next time he or she drops below 70. data WORK.GLU; infile datalines dsd truncover; input SubID:BEST12. DateTime:dATETIME. Glu:BEST12.; datalines4; 1,15MAY06:00:00:00,68 1,15MAY06:00:05:00,64 1,15MAY06:00:10:00,70 1,15MAY06:00:15:00,66 1,15MAY06:00:20:00,65 1,15MAY06:00:30:00,70 1,15MAY06:00:35:00,71 1,15MAY06:00:40:00,76 1,15MAY06:00:45:00,80 1,15MAY06:00:50:00,82 1,15MAY06:00:55:00,83 1,15MAY06:01:00:00,88 1,15MAY06:01:05:00,90 1,15MAY06:01:10:00,90 1,15MAY06:01:15:00,92 1,15MAY06:01:20:00,89 1,15MAY06:01:30:00,93 1,15MAY06:01:35:00,90 1,15MAY06:01:40:00,98 1,15MAY06:01:45:00,102 1,15MAY06:01:50:00,99 1,15MAY06:01:55:00,94 1,15MAY06:02:00:00,94 1,15MAY06:02:05:00,93 1,15MAY06:02:10:00,88 1,15MAY06:02:15:00,87 1,15MAY06:02:20:00,83 1,15MAY06:02:30:00,84 1,15MAY06:02:35:00,86 1,15MAY06:02:40:00,78 1,15MAY06:02:45:00,73 1,15MAY06:02:50:00,69 1,15MAY06:02:55:00,67 1,15MAY06:03:00:00,66 1,15MAY06:03:05:00,68 1,15MAY06:03:10:00,70 1,15MAY06:03:15:00,70 1,15MAY06:03:20:00,70 1,15MAY06:03:30:00,70 1,15MAY06:03:35:00,70 1,15MAY06:03:40:00,70 1,15MAY06:03:45:00,70 1,15MAY06:03:50:00,70 1,15MAY06:03:55:00,70 1,15MAY06:04:00:00,70 ;;;; The first event would last 25 minutes (starts when the meaurement dips to 68) at and the next dip occurs 130 minutes later and lasts 20 mins (starts when it dips to 69). In the scenario where we "run out" of data at the end so that we don't have 60 minutes worth of data after the last dip below 70 then the event would end at the last data point. I would like to output startDateTime, EndDateTime, eventNo, and eventDuration for each event per subject.
... View more