11-14-2014 07:03 PM
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.
11-15-2014 05:34 AM
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.
11-15-2014 12:59 PM
11-15-2014 01:37 PM
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;