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?
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