Why are times from an Excel file missing?

If you use the Database Wizard or GET DATA /TYPE=ODBC to read Excel files, times may be displayed as system-missing values. To display the time values correctly:

  1. In Variable View of the Data Editor, click the button that appears in the Type cell for the variable.
  2. In the Variable Type dialog, click Date and then select one of the time formats from the list (for example, hh:mm, hh:mm:ss, etc.).


  3. In a syntax window, run the following command:

    FORMATS varname (TIMEw.d)

    where w is the total number of characters you want to display, and d is the number of decimal positions to display.