@cruzerkk: You could use the ROUND function to round datetime_A to the nearest minute - as others have already pointed out, the SAS datetime value is number of seconds, so rounding to the nearest 60 will get you the minutes, e.g.: select
<columns>
from
<sqlserver table A> a
join
<sqlserver table B> b
on
b.<datetime variable>=round(a.<datetime variable>,60)
... View more