BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi all,

I have to export the SAS dataset to MS Access 2000 using SAS Unix. When I try to run the job, I am getting the following error.

ERROR: DBMS type ACCESS2000 not valid for export.

I am using SAS 9.1.2 version.

Request your help on resolving this error.

Thanks,
Satya
3 REPLIES 3
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
Please share the SAS-generated log with your SAS program code revealed.

Also, this SAS website DOC may be useful:

http://support.sas.com/documentation/cdl/en/acpcref/61891/HTML/default/a000611258.htm


Scott Barry
SBBWorks, Inc.
deleted_user
Not applicable
Please find the code snippets used for exporting the data set

PROC EXPORT DATA = My_data_set
OUTTABLE= GMP
DBMS=ACCESS2000 REPLACE;
DATABASE="/tmp/mydata.mdb";
RUN;

The log message is,

590 ! PROC EXPORT DATA = My_data_set
591 OUTTABLE= GMP
592 DBMS=ACCESS2000 REPLACE;
ERROR: DBMS type ACCESS2000 not valid for export.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
sbb
Lapis Lazuli | Level 10 sbb
Lapis Lazuli | Level 10
The pasted DOC link has a reference you want to review - it has the solution, which is to use LIBNAME - should still apply although here is the SAS 9.1.2 DOC point:

http://support.sas.com/documentation/onlinedoc/91pdf/index_912.html


Scott Barry
SBBWorks, Inc.

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
  • 3 replies
  • 970 views
  • 0 likes
  • 2 in conversation