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;
... View more