topic Export MS Access 2000 in Unix in Microsoft Integration with SAS

Export MS Access 2000 in Unix

deleted_user — Tue, 18 Aug 2009 16:15:04 GMT

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

Re: Export MS Access 2000 in Unix

sbb — Tue, 18 Aug 2009 17:14:10 GMT

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.

Re: Export MS Access 2000 in Unix

deleted_user — Tue, 18 Aug 2009 17:19:26 GMT

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

Re: Export MS Access 2000 in Unix

sbb — Tue, 18 Aug 2009 17:49:10 GMT

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.