Using PROC IMPORT with the USEDATE= option to import a Microsoft Excel file is not dropping the decimal value that represents the time portion of the datetime value.

Our documentation states that the options for USEDATE are "YES" and "NO". If the "Yes" option is used, then the DATE9. format is used for the date/time columns. If "No", the DATETIME19. format is used. However, the date value created from USEDATE=YES contains a decimal value representing the time portion of the datetime value.

As a result of not dropping this decimal value, users will get incorrect results when they compare the imported date against other date (integer) values. A workaround is to use functions such as DATEPART, ROUND, etc. on the new date value.