Time values that are greater than 24 hours are not exported properly when you use the EXCEL engine to export data to Microsoft Excel. The following example illustrates code that contains a time value greater than 24 hours:

When the time value is displayed in Excel, it is displayed as 1/0/1900 12:05:08 AM. To resolve this problem, do one of the following:

• For SAS^® 9.1.3, click the Hot Fix tab in this note to access the hot fix for this issue.
• For SAS^® 9.2 TS1M0, export time vaules with the DATETIME20. format, as shown in the following example:
  data toto; input time time8.; timeTime8=time; timeDatetime20=time; format timeTime8 time8. timeDatetime20 datetime20.; cards; 48:05:08 ; run; proc export data=toto outfile="filename.xls" dbms=excel; sheet="sheet-name"; run;
• For SAS 9.2 TS2M0, do one of the following:
  • Upgrade to SAS 9.2 TS2M2 or later.
  • Use the XLS engine (DBMS=XLS) to export your data.
  • Use the DATEETIME20. format to export the data.

Operating System and Release Information

A fix for SAS 9.1.3 (9.1 TS1M3) for this issue is available at:

A fix for SAS 9.1.3 (9.1 TS1M3) with Asian Language Support (DBCS) for this issue is available at: