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
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.