max number of variables sas can import from excel

[ErikLund_Jensen]

Hi @ilikesas 

Try using the XLSX libname engine instead of Proc Import. Example:

libname datain xlsx 'c:\temp\testsheet.xlsx';

proc copy inlib=datain outlib=work;
	select SHEET1;
run;

337  libname datain xlsx 'c:\temp\testsheet.xlsx';
NOTE: Libref DATAIN was successfully assigned as follows:
      Engine:        XLSX
      Physical Name: c:\temp\testsheet.xlsx
338  proc copy inlib=datain outlib=work;
339      select SHEET1;
340  run;

NOTE: Copying DATAIN.SHEET1 to WORK.SHEET1 (memtype=DATA).
NOTE:    Variable Name Change.  S.NO -> S_NO
NOTE:    Variable Name Change.  AUTHORIZATION LEVEL -> AUTHORIZATION_LEVEL
NOTE: BUFSIZE is not cloned when copying across different engines. System Option for BUFSIZE was used.
NOTE: The import data set has 72 observations and 6 variables.
NOTE: There were 72 observations read from the data set DATAIN.SHEET1.
NOTE: The data set WORK.SHEET1 has 72 observations and 6 variables.
NOTE: PROCEDURE COPY used (Total process time):
      real time           0.04 seconds
      cpu time            0.01 seconds