PROC IMPORT

Accepted Solution Solved
Reply
Super Contributor
Posts: 1,040
Accepted Solution

PROC IMPORT


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


Accepted Solutions
Solution
‎06-26-2015 12:36 PM
Super User
Super User
Posts: 6,502

Re: PROC IMPORT

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.

View solution in original post


All Replies
Solution
‎06-26-2015 12:36 PM
Super User
Super User
Posts: 6,502

Re: PROC IMPORT

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.

Super Contributor
Posts: 1,040

Re: PROC IMPORT

Thanks Tom,

I changed it to XLSX and it worked.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 187 views
  • 0 likes
  • 2 in conversation