Unable to export dataset to MS Access database

alankw2803 — Thu, 16 Jan 2020 15:49:50 GMT

I encounter the following errors when trying to export a dataset to MS Access database

ERROR: DBMS type ACCESS not valid for export.

========================================================================================

filename mem_pen '\\wfshkg02\USERS\Guest Loyalty and Engagement\CRM & Loyalty\DreamElite Report\Member Penetration\member_penetration.accdb';

proc export
data=work.MEMBER_PENETRATION_01
outtable="member_penetration"
DBMS=ACCESS replace;
database= mem_pen

run;

===============================================================================

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program';
4 %LET _CLIENTPROCESSFLOWNAME='Member Penetration Rate';
5 %LET _CLIENTPROJECTPATH='C:\SAS EG Task\S040_Member_Penetration\Member On Board Penetration.egp';
6 %LET _CLIENTPROJECTPATHHOST='HKGPDOR010023D0';
7 %LET _CLIENTPROJECTNAME='Member On Board Penetration.egp';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 FILENAME EGSR TEMP;
15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16 STYLE=HtmlBlue
17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
18 NOGTITLE
19 NOGFOOTNOTE
20 GPATH=&sasworklocation
21 ENCODING=UTF8
22 options(rolap="on")
23 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
24
25 GOPTIONS ACCESSIBLE;
26 filename mem_pen '\\wfshkg02\USERS\Guest Loyalty and Engagement\CRM & Loyalty\DreamElite Report\Member
26 ! Penetration\member_penetration.accdb';
27
28

29 proc export
30 data=work.MEMBER_PENETRATION_01
31 outtable="member_penetration"
32 DBMS=ACCESS replace;
ERROR: DBMS type ACCESS 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

33 database= mem_pen
34
35 run;
36
37
38
39
40
41
42 GOPTIONS NOACCESSIBLE;
43 %LET _CLIENTTASKLABEL=;
44 %LET _CLIENTPROCESSFLOWNAME=;
45 %LET _CLIENTPROJECTPATH=;
46 %LET _CLIENTPROJECTPATHHOST=;
47 %LET _CLIENTPROJECTNAME=;
48 %LET _SASPROGRAMFILE=;
2 The SAS System Thursday, January 16, 2020 10:42:00 PM

49 %LET _SASPROGRAMFILEHOST=;
50
51 ;*';*";*/;quit;run;
52 ODS _ALL_ CLOSE;
53
54
55 QUIT; RUN;

Re: Unable to export dataset to MS Access database

Reeza — Thu, 16 Jan 2020 16:24:15 GMT

Start by checking your license, you need SAS/Access to PCFILES.
Run the following and check your log.

proc product_status;run;

Re: Unable to export dataset to MS Access database

jebjur — Fri, 24 Jan 2020 19:35:57 GMT

If your site is licensed for SAS/Access to PC Files, another reason you may get this error is if you have a 64bit version of SAS and a 32bit version of MS Office. In this case there is a bitness mismatch. You will need to install and use a piece of software called PC FIle Server. Documentation and code examples can be found here:

https://go.documentation.sas.com/?docsetId=pcfsicg&docsetTarget=n1qhkerbd4k9qun1oome59qr7f5y.htm&docsetVersion=9.4&locale=en

topic Re: Unable to export dataset to MS Access database in SAS Enterprise Guide

Unable to export dataset to MS Access database

Re: Unable to export dataset to MS Access database

Re: Unable to export dataset to MS Access database