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.
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.
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.