topic Proc Export to Access in SAS Programming

Proc Export to Access

xavpontes — Wed, 21 Sep 2016 16:40:20 GMT

Please let me know the fix for this error message (please see attached file). Thank you.

Re: Proc Export to Access

ballardw — Wed, 21 Sep 2016 16:44:53 GMT

Can you verify that our PC Files Server is configured/working?

Re: Proc Export to Access

xavpontes — Wed, 21 Sep 2016 16:49:47 GMT

My PC Files Server was installed yesterday, 9/20/16. Thank you.

Re: Proc Export to Access

ballardw — Thu, 22 Sep 2016 15:18:56 GMT

Is the server local (running on your machine) or remote? If remote then you may be attempting to write to a location on the remote machine that either doesn't exist or you do not have permissions for.

You might investigate use of a LIBNAME statement for connection, especially if your data base already exists and you want to insert a new table. Proc Export tends to replace entire databases.

It would look something like:

LIBNAME mymdb PCFILES SERVER=D2323 PATH='c:\demo.mdb';

Then use like any other library:

Data mymdb.tablename;

set sashelp.air;

run;

Re: Proc Export to Access

xavpontes — Wed, 28 Sep 2016 22:07:31 GMT

Thank you all. The issue was the PC Files Server and it has been fixed.
My tech support had to work with SAS Technical Support on this. All
replies were helpful. Thank you again. Much appreciated.