HELP : Importing data - connection failed

[Waliyya]

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]

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]

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]

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]

http://blogs.sas.com/content/sasdummy/2012/05/01/64-bit-gotchas/