Version 5.1 (32-bit)   Operating System:   WX64_WKS. ... View more

Hi RW9, I've test your suggestion but without success. Could you please have a look to error?   Code: libname myxlsx  “Z:\Programs\file.xlsx”; data want;   set myxlsx.auto_dw_reportdetalhado (keep=CFK WF); run; libname myxlsx clear; Error: ERROR: The EXCEL engine cannot be found. ERROR: Error in the LIBNAME statement. 18         data want; 19           set myxlsx.auto_dw_reportdetalhado (keep=CFK WF); ERROR: Libname MYXLSX is not assigned. 20         run;   Thanks, MD ... View more

Hi KurtBremser,   I´ve used the codes below to import xlsx files, but the code gives error.   Code:  PROC IMPORT datafile='Z:\Programs\file.xlsx'        OUT=test DBMS=excel replace;     sheet='dw_names; RUN; Error: ERROR: DBMS type EXCEL not valid for import.   Code:  PROC IMPORT datafile='Z:\Programs\file.xlsx'        OUT=test DBMS=xlsx replace;     sheet='dw_names; RUN; Error: ERROR: DBMS type EXCEL not valid for import.   Do you have some idea to solve this? Thanks in advance. ... View more

Thanks Jag, It works! ... View more

Dear RW9, I've tried your solution but doesn't work, with the error below:    GOPTIONS ACCESSIBLE;   libname myxlsx xlsx "C:\Desktop\Imparidade\Test_Excel.xlsx"; ERROR: The EXCEL engine cannot be found. ERROR: Error in the LIBNAME statement.   Tks ... View more