topic Re: Error in imporing excel data to SAS in SAS Procedures

Error in imporing excel data to SAS

Srikanth_J — Fri, 25 May 2018 10:53:03 GMT

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.

Re: Error in imporing excel data to SAS

RW9 — Fri, 25 May 2018 10:57:26 GMT

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.

Re: Error in imporing excel data to SAS

Srikanth_J — Fri, 25 May 2018 10:58:54 GMT

I'm using SAS 9.4, on Win 10 64 bit

Re: Error in imporing excel data to SAS

Amir — Fri, 25 May 2018 11:46:04 GMT

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

Re: Error in imporing excel data to SAS

Srikanth_J — Fri, 25 May 2018 11:59:57 GMT

Thanks @ Amir

Re: Error in imporing excel data to SAS

Amir — Fri, 25 May 2018 12:09:43 GMT

@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.