SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Issues working with Microsoft Access

Reply
Contributor
Posts: 21

Issues working with Microsoft Access

We are using SAS PC File Server to connect to Microsoft Access 2007 database. The database is available as a libname using following command:

libname myLIBNAME pcfiles server="MY_MACHINE" port=8000 pathMY_DB.accdb";

We can read data from tables in the libname without any issues. But anytime we try to update the table, the SAS does not respond and we can only resolve this issue by killing SAS program from the Task manager. For example we add a row to the table using proc append command:

proc append data = data1 base = myLIBNAME.data2; run;

I will really appreciate any insight into this issue or if any one had a similar experience.

Thanks Message was edited by: model_coder
Contributor
Posts: 30

Re: Issues working with Microsoft Access

Hi,

you're probably facing the same issue as we are (with Excel files).

You might want to have a look at http://support.sas.com/kb/42/151.html (Usage Note 42151: PCFILES engine does not support MODIFY in a DATA Step)

hth,
Thomas
Post a Question
Discussion Stats
  • 1 reply
  • 147 views
  • 0 likes
  • 2 in conversation