Hi @Babloo
Your datetime-value contains seconds, which is proved when the value is loaded into SQL, where it is displayed with seconds. And - as pointed out by other contributors - it is a SQL problem to suppress the display of seconds, when the actual value contains seconds.
In SAS, you use a format which displays only minutes, but this doesn't change the value of the variable, only the way it is displayed.
But if you change the value in SAS by removing the seconds after last completed minute before load, the value is loaded without seconds, so 2019-09-18 12:49:56.000 is displayed as 2019-09-18 12:49:00.000 in SQL. It is still displayed the same way in SAS.
Then the same value is displayed i SAS and SQL, only padded in SQL with zeroes for seconds and miliseconds. I don't know if this will solve your problem, but it is the only way I can imagine to get rid of the seconds in SAS before load.
You can remove the seconds with this expression: dtvalue = floor(dtvalue/60)*60;
... View more