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
... View more