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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.