PROC IMPORT

robertrao — Fri, 26 Jun 2015 16:27:15 GMT

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

Re: PROC IMPORT

Tom — Fri, 26 Jun 2015 16:36:10 GMT

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.

Re: PROC IMPORT

robertrao — Fri, 26 Jun 2015 16:41:07 GMT

Thanks Tom,

I changed it to XLSX and it worked.

topic Re: PROC IMPORT in SAS Programming

PROC IMPORT

Re: PROC IMPORT

Re: PROC IMPORT