Help using Base SAS procedures

Error in imporing excel data to SAS

Reply
New Contributor
Posts: 3

Error in imporing excel data to SAS

Hi,

 

I'm getting the following error while importing excel(.xlsx) data into SAS.

 

ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement.
Connection Failed. See log for details.

 

Thanks in Advance. 

Super User
Super User
Posts: 9,599

Re: Error in imporing excel data to SAS

Posted in reply to Srikanth_J

Can you supply some information.  What SAS product are you using.  What OS its installed on, local or server.  What code your running. Sounds like your using the XLSX engine, but its not installed.

New Contributor
Posts: 3

Re: Error in imporing excel data to SAS

I'm using SAS 9.4, on Win 10 64 bit
Super Contributor
Posts: 340

Re: Error in imporing excel data to SAS

Posted in reply to Srikanth_J

Hi,

 

It looks like a similar question was solved as follows:

 

https://communities.sas.com/t5/SAS-Enterprise-Guide/Error-Connect-Class-not-registered/td-p/184367

 

Other potentially useful links are:

 

http://support.sas.com/kb/60/356.html

http://support.sas.com/kb/52/649.html

http://support.sas.com/kb/43/933.html

 

All the links were found by doing a web search on the message you posted "error: Connect: Class not registered".

 

HTH.

 

 

Regards,

Amir.

New Contributor
Posts: 3

Re: Error in imporing excel data to SAS

Thanks @ Amir
Super Contributor
Posts: 340

Re: Error in imporing excel data to SAS

Posted in reply to Srikanth_J

@Srikanth_J, No problem.

 

If you're just thanking me for my response then thank you too.

 

If you're thanking me because it is the solution then it is best practice to also mark the answer as the solution to assist others, just like the first link I sent was a help in this case.

 

 

Regards,

Amir.

Ask a Question
Discussion stats
  • 5 replies
  • 157 views
  • 0 likes
  • 3 in conversation