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.
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).
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.
Register Today!
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.