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

Exporting Data into Access

Reply
N/A
Posts: 1

Exporting Data into Access

I am attempting to automatically transfer the results of a series of queries into MS Access as tables. The transfer works well except for the 'Replace' option. I get an error stating 'This engine does not support the REPLACE option." I'm using SAS 8.01. Is there a workaround for this issue? I can't delete or rename the Access tables because they are used in further querying.
N/A
Posts: 0

Re: Exporting Data into Access

I use the code
+++++++++++
PROC EXPORT DATA = PS_CLASS_TBL
OUTTABLE = "PS_CLASS_TBL"
DBMS = ACCESS REPLACE;
DATABASE = "c:\CRSE_FACULTY_GRADUATE.MDB";
QUIT;
++++++++++
and don't get the replace error. I'm in version 9. Does the MS Access file *.mdb exist prior to the export? I recall getting the 'engine does not support...' error when I used a libname statement instead of proc export.

As in:
Libname faculty access "c:\CRSE_FACULTY_GRADUATE.MDB";

data faculty.ps_class_tbl;
set work.ps_class_tbl
run;

Another thing, are your SAS results in a view or a 'real' dataset? I've gotten mixed results using views instead of datasets.
Ask a Question
Discussion stats
  • 1 reply
  • 201 views
  • 0 likes
  • 2 in conversation