I recently upgraded my laptop to Windows 10 and installed SAS 9.4. Below is a procedure I frequently used when I had SAS 9.3 before to export a dataset to Access. Since I got my new laptop which has Windows 10 and SAS 9.4, I have been having trouble running this. I kept getting this message, " ERROR: Connection Failed. See log for details." PROC EXPORT DATA = APPNDRANK DBMS = ACCESS REPLACE OUTTABLE = "ELIGRANK"; DATABASE = "C:\Vickie_SAS\BOOM_ELIGRANK.MDB"; RUN; I did some research - tried to changed it to ACCESSCS, but still got the same error message. Could you please help? Thanks!
... View more