SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Export MS Access 2000 in Unix

Reply
N/A
Posts: 0

Export MS Access 2000 in Unix

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
Super Contributor
Super Contributor
Posts: 3,174

Re: Export MS Access 2000 in Unix

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.
N/A
Posts: 0

Re: Export MS Access 2000 in Unix

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
Super Contributor
Super Contributor
Posts: 3,174

Re: Export MS Access 2000 in Unix

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.
Ask a Question
Discussion stats
  • 3 replies
  • 388 views
  • 0 likes
  • 2 in conversation