topic SAS VI does not display the correct time format for the column that contains the time value. in New SAS User

SAS VI does not display the correct time format for the column that contains the time value.

Siddharth_s — Fri, 25 Nov 2022 12:16:48 GMT

Hi all,

SAS VI (10.8) does not display the correct time format. I am using the database MS SQL Server and the value of the variable contains is 00:03:37 and the datatype of the variable is time(7). SAS VI (10.8) shows the date and time as January 1, 1970 12:08:58 am.

Ex -

ResTime

Jan 1, 1970 12:08:58 AM

Re: SAS VI does not display the correct time format for the column that contains the time value.

fja — Fri, 25 Nov 2022 20:55:38 GMT

And if you used time. as a format? E.g.

format TimeVar time.;

in the data step?

The date 1/1/1970 makes (sort of) sense, as you just have a time as input and the integer value of 0 is interpreted as 1/1/1970 0:00 on unix-like systems (i.e. the beginning of time).

Re: SAS VI does not display the correct time format for the column that contains the time value.

SASKiwi — Fri, 25 Nov 2022 21:46:56 GMT

Since you are getting this result in a SAS product, not through your own SAS programs, I suggest opening a Tech Support track for this. It's obvious that SAS is treating the time column as a datetime.