topic Re: HELP : Importing data - connection failed in SAS Procedures

HELP : Importing data - connection failed

Waliyya — Sat, 15 Nov 2014 00:03:02 GMT

Hello everyone,

I'm trying to import some data into SAS but I repeatedly receive an error message saying that the connection failed.

(I use 64-bit windows)

You'll find attached 2 pictures showing the messages I receive.

Can someone help me solve this problem please ??

Thanking you in advance.

jakarman — Sat, 15 Nov 2014 10:34:10 GMT

Please check your bitness. It could be SAS is 64-bit and your office 32-bit or vice versa.

The error message in English is more easy to find as this French one.

Waliyya — Sat, 15 Nov 2014 17:59:38 GMT

I have a 64 bit windows and I have installed SAS in 64 bits. Yet I still get this problem. What do I do ?

Despite creating the excel file myself, I still cannot import the table into SAS and I get the same message, see attached.

I have tried on other computers (at university) and it works.

Tom — Sat, 15 Nov 2014 18:37:06 GMT

You need to post the actual code that you tried with PROC IMPORT. Also what version of SAS you are using.

It appears you are using PC- SAS rather than a Unix version.

If you are using a new enough version of SAS it should be able to read XLSX files without trying to connect to MicroSoft tools.

proc import datafile='myfile.xlsx' out=mydata replace dbms=xlsx; run;

jakarman — Sat, 15 Nov 2014 18:53:10 GMT