topic Data import from Access 2013 to SAS 9.3 in SAS Data Science

Data import from Access 2013 to SAS 9.3

mlogan — Tue, 19 May 2015 20:52:10 GMT

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

Re: Data import from Access 2013 to SAS 9.3

Kurt_Bremser — Wed, 20 May 2015 05:31:19 GMT

I think your error message does not appear in the log, but as a pop-up from Enterprise Guide. Am I correct?

Re: Data import from Access 2013 to SAS 9.3

mlogan — Wed, 20 May 2015 17:44:09 GMT

Hi KurtBremser,

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

Thanks,

Re: Data import from Access 2013 to SAS 9.3

M_Maldonado — Wed, 20 May 2015 19:27:37 GMT

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

Re: Data import from Access 2013 to SAS 9.3

SASKiwi — Wed, 20 May 2015 19:43:43 GMT

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.

Re: Data import from Access 2013 to SAS 9.3

Kurt_Bremser — Thu, 21 May 2015 05:23:41 GMT

Then this should help you: