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.
I use the code
PROC EXPORT DATA = PS_CLASS_TBL
OUTTABLE = "PS_CLASS_TBL"
DBMS = ACCESS REPLACE;
DATABASE = "c:\CRSE_FACULTY_GRADUATE.MDB";
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.
Libname faculty access "c:\CRSE_FACULTY_GRADUATE.MDB";
Another thing, are your SAS results in a view or a 'real' dataset? I've gotten mixed results using views instead of datasets.