Hello, I want to know how do I calculate the consecutive flagged observations and create an event. So lets say in this example for ID 1 we see that we have flags at 2 and 3 OBS that are consecutive and hence the event would be 2 days long. Similarly in id 2, we have 2 events, 1 st one from obs 7 to 9 which is 3 day long and another is obs 12 to 13 which is 2 day long. The total length of event is 5 days. Can someone help me with this? obs id flag Count day 1 1 0 0 2 1 1 1 3 1 1 2 4 1 0 0 5 1 1 1 6 2 0 0 7 2 1 1 8 2 1 2 9 2 1 3 10 2 0 0 11 2 0 0 12 2 1 1 13 2 1 2 Required output id Total event Total Length of event 1 2 3 2 2 5
... View more