BookmarkSubscribeRSS Feed
mlogan
Lapis Lazuli | Level 10

I am trying to import data from Access 2013 to SAS 9.3 with the following code. Can anyone tell me what is the mistake I am doing?

PROC IMPORT DBMS=ACCESSCS replace;

OUT=Apple.MyDATA1

DATATABLE='details';

DATABASE="E:\SAS\MyTable.accdb";

RUN;3

I get the following error:

ERROR: Failed to connect to the Server

5 REPLIES 5
mlogan
Lapis Lazuli | Level 10

Hi KurtBremser,

It appears in the log. I still have that problem, plz let me know if you can help.

Thanks,

M_Maldonado
Barite | Level 11

Logan,

Enterprise Guide supports importing access databases. Have you tried to do File->Import Data?

Also give it a try posting your question on Data Management and Base SAS procedures communities.

Good luck!

-M

SASKiwi
PROC Star

DBMS=ACCESSCS requires that you have the SAS PC File Server installed and operating on either your PC or on a remote server you have access to - this could be your SAS server. The usual reason for using this is to deal with 64-bit versus 32-bit incompatibilities. The error you got indicated it couldn't connect to the SAS PC File Server.

You could also try DBMS = ACCESS. This method doesn't require the SAS PC File Server but if your SAS server is 64-bit it would need to have 64-bit MS Office components installed.  

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 5 replies
  • 1690 views
  • 0 likes
  • 4 in conversation