So here is the deal, I have two SQL Server Tables (A & B) which I want to merge using Proc sql. Table A has variable datetime_A and Table B has variable datetime_B. datetime_A format : yyyy-mm-dd hh:mm:ss:mil datetme_B format: yyyy-mm-dd hh:mm:ss Further, the datetime_A is accurate to the milliseconds and datetime_B has its seconds rounded (which means the seconds are always 00) In essence i want to compare only till the minutes part. I figured I will have to somehow convert the datetime to a char or varchar till the minutes part and compare the two in my join clause. I'm unable to arrive at the correct syntax to do the same. Any help is greatly appreciated.
... View more