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.
Ready to join fellow brilliant minds for the SAS Hackathon?
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.