DATA Step, Macro, Functions and more

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

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 80
Accepted Solution

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

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

 


Accepted Solutions
Solution
‎05-30-2016 10:26 PM
Super User
Posts: 5,430

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

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

View solution in original post


All Replies
Solution
‎05-30-2016 10:26 PM
Super User
Posts: 5,430

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

Perhaps a SQL right join with a table1.end between table2.end - 2 minutes and table.end + 2 minutes join criteria (pseudo code)?
Data never sleeps
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 168 views
  • 0 likes
  • 2 in conversation