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
I think your error message does not appear in the log, but as a pop-up from Enterprise Guide. Am I correct?
Hi KurtBremser,
It appears in the log. I still have that problem, plz let me know if you can help.
Thanks,
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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.