topic Re: How to round the time in New SAS User

How to round the time

P_Y — Mon, 12 Sep 2022 04:10:00 GMT

What function can I use to change:

2014-07-09 11:42:34:826 --> 2014-07-09 11:42:34

Re: How to round the time

SASKiwi — Mon, 12 Sep 2022 04:42:12 GMT

Is that value stored in a numeric or character SAS variable? If it is numeric, what format is applied to it?

Re: How to round the time

P_Y — Mon, 12 Sep 2022 06:40:49 GMT

Is DATETIME22.3 format.
I tried to compute columns by using Timepart(2014-07-09 11:42:34:826) to get the time and in format TIME8, but it round up to 11:42:35. I just want to round down to 11:42:34:000.

Re: How to round the time

PeterClemmensen — Mon, 12 Sep 2022 06:43:08 GMT

SAS Datetime values are integers until the milliseconds part. So given that your values are actual numeric datetime values, you can use the Floor or Round Function depending on what you want.

Or you can find an appropriate SAS format if you do not want to change the actual values.

Re: How to round the time

Ksharp — Mon, 12 Sep 2022 11:12:48 GMT

As Perter.C said, add one more function in it .

Timepart( int( 2014-07-09 11:42:34:826 ) )

Re: How to round the time

Patrick — Mon, 12 Sep 2022 11:13:18 GMT

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.