Dear All,
I want to export dataset (.bdat) to ".accdb", but the SAS System Stopped Processing the step.
i used this step to export the dataset:
PROC EXPORT DATA= ccmart.appcard_20202021_datamart
OUTTABLE= "Sheet1"
DBMS=ACCESSCS REPLACE;
DATABASE="C:\SAS_TEMP\CARD_TEMP\DATAMART_TEMP\appcard_20202021_datamart.accdb";
RUN;
when i run the export step, the system stop processing because this error below;
ERROR: CLI execute error: [Microsoft][ODBC Microsoft Access Driver] Cannot open database '|'. It may
not be a database that your application recognizes, or the file may be corrupt.
WARNING: File deletion failed for _IMEX_.Sheet1.DATA.
ERROR: Export unsuccessful. See SAS Log for details.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 7:12.00
cpu time 10.29 seconds
Note: i run this step daily, but today the error show up. (The file that succeed to export, has size > 2 gigabytes)
for further information
- SAS 9.4
- size of dataset that i want to export is 515 megabytes
- Office 365
Is this a new Access database or an existing one? If it is existing then try writing to a new one in case the existing one is corrupt.
it was an exisiting accdb file name. I created a new accdb filename as you suggested, and it was worked, but it couldn't run for the second time coz the same error.
It seems that you don't have access to replace the Access database.
Isn't the file being used for your SAS process? This could be a reason for your problem.
Try creating a new file and then merge with the previous file.
This is a knowledge-sharing community for learners in the Academy. Find answers to your questions or post here for a reply.
To ensure your success, use these getting-started resources:
Estimating Your Study Time
Reserving Software Lab Time
Most Commonly Asked Questions
Troubleshooting Your SAS-Hadoop Training Environment