BookmarkSubscribeRSS Feed
SWolfe
Calcite | Level 5
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.
1 REPLY 1
deleted_user
Not applicable
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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

Discussion stats
  • 1 reply
  • 872 views
  • 0 likes
  • 2 in conversation