topic Re: Error in SAS import..connection failed & error in libname statement in SAS Data Management

Error in SAS import..connection failed & error in libname statement

dr2014 — Fri, 27 Mar 2015 19:11:59 GMT

Hi All,

I was using the point and click import feature in SAS to import an excel file and it gives me a message and says' connection failed' and 'error in libname' statement. I researched a bit and the information was for older versions of SAS. I use SAS 9.4. Also, the file I was trying to import is placed on a flash drive. Please let me know you suggestions.

Thanks.

Re: Error in SAS import..connection failed & error in libname statement

dr2014 — Fri, 27 Mar 2015 19:20:55 GMT

Basically, this is the message I am getting when I import an excel file

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement

Re: Error in SAS import..connection failed & error in libname statement

ballardw — Fri, 27 Mar 2015 20:03:07 GMT

What was the libname statement?

Re: Error in SAS import..connection failed & error in libname statement

TomKari — Fri, 27 Mar 2015 21:23:20 GMT

I remember something similar. EG imports the dataset, and moves it via FTP to a temp location on the server, from which SAS on the server copied it to my final library. There was a problem with access to the temp location, so the export failed, but the problem was difficult to trace and required some SAS expertise.

Tom

Re: Error in SAS import..connection failed & error in libname statement

LinusH — Sat, 28 Mar 2015 17:24:41 GMT

Are you in SAS Foundation in Windows? And do you use the Import Wizard?

What is the version and type (file extension) of the Excel file?

Full code and log would help.

Re: Error in SAS import..connection failed & error in libname statement

Kurt_Bremser — Mon, 30 Mar 2015 08:22:50 GMT

Looks like you try to use an access method for which you do not have the license and/or which is not installed.

Re: Error in SAS import..connection failed & error in libname statement

dr2014 — Mon, 30 Mar 2015 17:40:43 GMT

Thanks all for your input. I did use the import wizard. My excel file was on a flash drive.

For example the libname statement was:

libname a "E:\test";

The minute I start using the import wizard I get the message..connection failed and check log. My log looks like this...

ERROR: Connect: Class not registered

ERROR: Error in the LIBNAME statement.

NOTE: Attachments for -3 reestablished for new parent.

NOTE: Import Cancelled.

1 libname a "E:\test";

NOTE: Libref A was successfully assigned as follows:

Engine: V9

Physical Name: E:\test

Re: Error in SAS import..connection failed & error in libname statement

Kurt_Bremser — Tue, 31 Mar 2015 06:23:56 GMT

The ERROR does not refer to the libname a "E:\test"; statement. There mus be another libname before that that causes the error.

This may be helpful for you:

43933 - "Connection Failed" and "Connect: Class not registered" errors occur when using the Import Wizard with SAS® 9.3 on Windows X64 systems

37412 - Errors occur when you import Microsoft Excel or Microsoft Access files into SAS® 9.2

Re: Error in SAS import..connection failed & error in libname statement

dr2014 — Tue, 31 Mar 2015 13:29:07 GMT

Hi @KurtBremser..I don't have another libname before that caused the error. But, I do have 32 bit MS office and 64 bit SAS...so that might be the issue. Your links are helpful and second one might address the bit size issue. I just need the server name for that. Will keep you all posted. Thanks.

Re: Error in SAS import..connection failed & error in libname statement

dr2014 — Fri, 24 Apr 2015 19:11:31 GMT

Hi @KurtBremser and all,

The problem with SAS import wizard was resolved. Turns out the SAS PC files server was 64 bit which did not match with my 32 bit Windows Office. So the PC files server was stopped, uninstalled and the SAS PC files server 32 bit was installed. Steps on this link were followed

SAS Downloads: SAS PC Files Server.

I still got an error after that...which is

ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel Driver] General error Unable to open registry key Temporary (volatile) Ace DSN for process 0x490 Thread 0xbbc DBC 0x3bb7fdc Excel'. ERROR: Error in the LIBNAME statement

This error corresponded to a error number (40228) in SAS support which meant the Windows drivers were old and needed to be replaced. The following link helped correct the problem 40228 - "Volatile ACE DSN" errors occur when you import Microsot Excel files using the EXCELCS engine or PCFILES engine

SAS provided technical support to resolve this issue. Here is the documentation for 9.4 PC files server http://support.sas.com/documentation/cdl/en/pcfsicg/67728/PDF/default/pcfsicg.pdf

Thanks !