I do have a base SAS 9.4 installed on my computer . looks like there are some restrictions to it. I have been trying to import the excel files into the SAS but it is not letting me do it. I tried using older excel format 2003-007 and also tried using latest excel 2013. none of them work. here is the log. NOTE: Additional host information: X64_7PRO WIN 6.1.7601 Service Pack 1 Workstation NOTE: SAS initialization used: real time 1.33 seconds cpu time 0.56 seconds 1 2 3 libname xdb excel "C:\Users\nabinneupane\Desktop\IP.xlsx"; ERROR: The EXCEL engine cannot be found. ERROR: Error in the LIBNAME statement. 4 5 PROC IMPORT OUT= WORK.EMPLOYEE 6 DATAFILE= "C:\Users\nabinneupane\Desktop\IP.xlsx" 7 DBMS=xlsx REPLACE ; ERROR: DBMS type XLSX not valid for import. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process tiing eceme): real time 0.00 seconds cpu time 0.00 seconds 8 GETNAMES=YES; 9 MIXED=NO; 10 SCANTEXT=YES; 11 USEDATE=YES; 12 SCANTIME=YES; 13 RUN;
... View more