I'm trying to import an Excel file but receive the following error: ERROR: Connect: Class not registered ERROR: Error in the LIBNAME statement. ERROR: Database error. Examine fields and/or messages below. The file specified is not an Excel 4, 5, or 7 (Excel 95) file. ERROR: Database table must be entered first ERROR: Database table must be entered first ERROR: File WORK._IMEX_.DATA does not exist. This is the code I used: PROC IMPORT OUT= data DATAFILE= "directory\filename.xls" DBMS=EXCEL REPLACE; RANGE="Sheet$"; GETNAMES=YES; MIXED=YES; SCANTEXT=YES; USEDATE=YES; SCANTIME=YES; RUN; Any suggestions on what it could be? Thank you!
... View more