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

[Siddharth_s]

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

[fja]

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).

[SASKiwi]

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.