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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.