Thanks Kurt, but i think i may have explained my need poorly. Let me try again. At the start of my code I only want to input two times: Call start time - '26APR2018:14:30:10'dt Call end time - '26APR2018:14:45:09'dt These should be be auto calculated for use in my query as follows (notice the 5 second variance from my given times above): Start query 1 = '26APR2018:14:30:05'dt Start query 2 = '26APR2018:14:30:15'dt End query 1 = '26APR2018:14:45:04'dt End query 2 = '26APR2018:14:45:14'dt These would then be in a query as such (text in bold represent the column names in my data) proc sql; create table want as select * from have where callstartime >= &Start Query 1. and callstarttime <= &Start Query 2. and callendtime >= &End Query 1. and callendtime <= &End Query 2. ; quit; The reason behind this methodology is due to my two data sets, PhoneLogA and PhoneLogB, containing information about the same calls but for some reason the start and end times vary between them. As such, if someone hands me call details of one phonecall from LogA and asks me to find extra info on that call from LogB I want to be able to input the exact details of LogA, and for my code to auto calculate the variance and search between these values in LogB. Annoyingly there is no unique identifier between the two to make life easy so the above is needed.
... View more