Event occurrence, time threshold

[sartol]

Hello!

I have a list of events with time stamps.

I am trying to filter out events that don't occur within two minutes of another type of event.

Any suggestions?

[DawnDuong]

Hi @sartol 

i would be using an iterative macro to solve this. Assume you already sorted the time stamps in ascending order (oldest to newest), The schematic is:

for each loop: 

1) take the first record > take the time stamp of the first record > use datetimeadd to add 2 minto it

2) take all records whose time stamps < the upper bound in the first step

3) do a unique concatenate to find the combinations of events that occur in that 2min interval > pass that to to the non-looping macro output

4) knock the 1st record off then loop again.

End loop

after that you will have a list of the combinations of events that happen in all 2min moving window.

a simple matter to find out how many times you have a certain combi. 
dawn