Help using Base SAS procedures

HELP : Importing data - connection failed

Reply
Occasional Contributor
Posts: 9

HELP : Importing data - connection failed

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.


Erreur SAS importer.pngErreur SAS import.png
Trusted Advisor
Posts: 3,215

Re: HELP : Importing data - connection failed

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.

---->-- ja karman --<-----
Occasional Contributor
Posts: 9

Re: HELP : Importing data - connection failed

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.

Super User
Super User
Posts: 7,080

Re: HELP : Importing data - connection failed

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;

Trusted Advisor
Posts: 3,215

Re: HELP : Importing data - connection failed

Ask a Question
Discussion stats
  • 4 replies
  • 428 views
  • 3 likes
  • 3 in conversation