DATA Step, Macro, Functions and more

Proc Export to Access

Reply
Occasional Contributor
Posts: 9

Proc Export to Access

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

Super User
Posts: 10,500

Re: Proc Export to Access

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

Occasional Contributor
Posts: 9

Re: Proc Export to Access

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

Super User
Posts: 10,500

Re: Proc Export to Access

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;

 

 

Occasional Contributor
Posts: 9

Re: Proc Export to Access

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.

Ask a Question
Discussion stats
  • 4 replies
  • 379 views
  • 1 like
  • 2 in conversation