SAS datetime values are stored as the count of seconds since 1/1/1960. They are stored in a numerical values, can include fractional seconds and you can use any operator that's suitable for numerical values.
In your case: If you would want to round to seconds shouldn't the formatted value be 2014-07-09 11:42:35
Given your dealing with a numerical variable and depending what you want use either of the following functions:
- round()
- int()
- floor()
- ceil()
These functions area all documented under: https://go.documentation.sas.com/doc/en/pgmsascdc/9.4_3.2/lefunctionsref/n01f5qrjoh9h4hn1olbdpb5pr2td.htm
One of them will give you exactly what you want.
And last but not least: If it's just about printing the internal value without fractional seconds then use DATETIME22. ...but be aware that this will use arithmetic rounding so it will be 35 seconds.
... View more