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;
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:
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.