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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.