How to determine if a 2nd service was done within 2 min of the other

Beto16 — Fri, 27 May 2016 15:53:15 GMT

Hi team I'm working on 2 tables an I need to determine if table1 service A was done within 2 min of table2 service B..

And also to determine how many service B did not have any service A here is example

TABLE 1

ID. Ser Start. End

Qw. A 23May2016:00:34:00. 23May2016:00:40:00

TABLE 2

ID. Ser Start. End

Qw. B 23May2016:00:35:00. 23May2016:00:41:00

In the example table One open within 2 min of the 2nd service I would want to see table two in a dataset

That's first part here is 2nd part

TABLE 1

ID. Ser Start. End

Qw. A 26May2016:00:29:00. 26May2016:00:40:00

TABLE 2

ID. Ser Start. End

Qw. A 26May2016:00:38:00. 26May2016:00:40:00

On this example what it's showing is there was a service B but no service A open up within 2 min I would want that on its own dataset .... thanks again for help ay

Re: How to determine if a 2nd service was done within 2 min of the other

LinusH — Sat, 28 May 2016 21:34:33 GMT

Perhaps a SQL right join with a table1.end between table2.end - 2 minutes and table.end + 2 minutes join criteria (pseudo code)?

topic How to determine if a 2nd service was done within 2 min of the other in SAS Programming

How to determine if a 2nd service was done within 2 min of the other

Re: How to determine if a 2nd service was done within 2 min of the other