I'm having a bit of trouble with SAS Enterpise Guide to export a Access database. I'm running 64-bit Windows, 32-bit SAS. I've downloaded the PC File Server. I am using the next code.
proc export
data=work.rr_if
outtable='ACCESS'
dbms=ACCESS replace;
database='D:\Users\martin\Desktop\prueba.mdb';
run;
When i run the program, i get "Connection Failed. See log for details." I need more details.
Someone can i help me?.
Thanks, Felix.
Check whether the PC File Server process is running.
If possible post the complete error message.
And what does the log say?
Hi
In order to use the SAS PC File Server with Proc EXPORT, you need to use dbms=ACCESSCS instead of dbms=ACCESS, see also code below.
proc export
data=sashelp.class
outtable='fromSAS'
dbms=ACCESSCS
replace
;
database='c:\temp\sample.mdb';
run;
Bruno
Try changing
database='D:\Test.mdb';
to
database='D:\Test.accdb';
The file extensions changed.
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!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.