When you use the IMPORT procedure (PROC IMPORT) with the XLSX engine and the RANGE= option, it is possible that zero observations are read. The problem occurs even when there is data present in the sheet, as shown in this example below:

   proc import datafile = "c:\myexcel.xlsx"
      out = col_names
      dbms = xlsx
      replace;
      range = 'excel table$A1:A6';
   run;

NOTE: The import data set has 0 observations and 1 variables.
NOTE: WORK.COL_NAMES data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.04 seconds
      cpu time            0.03 seconds

The problem occurs when the sheet name contains the word EXCEL and a space. To resolve the problem, change the sheet name so that it does not contain the word EXCEL with a space.

Operating System and Release Information