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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: