I'm attempting to use the INTCK function to calculate the number of minutes between two dates but am getting the wrong answer. When I calculate intck('min',"21JUL2017 9:06"d,"23JUL2017 :10:28"d) I get 2,666 minutes. When I calculate ("23JUL2017 :10:28"d-"21JUL2017 9:06"d)/(1440*60) I get 2,665.483 minutes. When I calculate the same in MS Excel, I get 2,962 minutes which is correct. I did observe that SAS calculates the difference in minutes correctly when the two dates are the same; just differs in time. I'm certain this has something to do with how SAS defines 'intervals' but I'm at a loss how to fix this. Please advise. Thanks! Sam
... View more