PROC IMPORT

[robertrao]

Hi ,

I am trying to import a file and it throws an error.

Could you help me figure out the mistake?

Thanks

proc import datafile="C:\Data\Projects\Jun_2015\SNF1 placement detail.xlsx"
20   out=SNF_data
21   dbms=excel replace;
22   getnames=yes;
23   run;

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
Connection Failed.  See log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE IMPORT used (Total process time):
      real time           0.21 seconds
      user cpu time       0.18 seconds
      system cpu time     0.03 seconds
      memory              319.03k
      OS Memory           9688.00k
      Timestamp           06/26/2015 11:24:23 AM
      Step Count                        5  Switch Count  0

[Tom · Accepted solution]

Not sure why you are getting the error, but try changing the DBMS option to XLSX and avoid any attempt to use microsoft products to read the file.

[robertrao]

Thanks Tom,

I changed it to XLSX and it worked.