topic Re: Why am i unable to see the export to .mbd file? in SAS Enterprise Guide

Why am i unable to see the export to .mbd file?

Mark5 — Wed, 23 May 2018 09:02:21 GMT

Please can someone assist.

i want to export a table as an .mbd file but it is not givving me the option to.

I do have access 2016 installed aswell.

Am i missing something or do i need to enable something for this tio reflect.

i have attached a screenshot.

Thanks

Re: Why am i unable to see the export to .mbd file?

RW9 — Wed, 23 May 2018 09:44:24 GMT

Really can't state this enough here, mdb is ancient, drop the file format. If you have to use Access at all, use accdb, mdb hasn't been used since 2003.

As for why you can't see it, can't even tell what SAS you are using, looks to be some sort of wizard. This will show you the code:
https://communities.sas.com/t5/SAS-Data-Management/Export-SAS-9-4-file-to-Access-mdb/td-p/255055

Re: Why am i unable to see the export to .mbd file?

Mark5 — Wed, 23 May 2018 09:52:07 GMT

Thank you for the response, i am using EG 7.1. i have tried code as well. see below:

PROC
EXPORT
DATA= ALL_POLICIES
            OUTTABLE= "POLICIES SPLIT"
            DBMS=ACCESSCS
            REPLACE;
DATABASE="C:\Users\abmc677\Desktop\BookSPLIT.accdb";
run
;

Then i get the error: ERROR: Server Name is invalid or missing.

Thanks

Re: Why am i unable to see the export to .mbd file?

RW9 — Wed, 23 May 2018 10:06:48 GMT

Try:

proc export data=all_policies
            outtable="policies split"
            dbms=access
            replace;
   database="<path>/booksplit.accdb";
run;

http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#p1d0tocg3njhmfn1d4ld2covlwm0.htm

accesscs is trying to use pcfiles.

Re: Why am i unable to see the export to .mbd file?

Mark5 — Wed, 23 May 2018 10:17:07 GMT

i tried

proc export data=all_policies
            outtable="policies split"
            dbms=access
            replace;
   database="C:/Users/abmc677/Desktop/booksplit.accdb";
run;

get the following error: ERROR: DBMS type ACCESS not valid for export.

Re: Why am i unable to see the export to .mbd file?

RW9 — Wed, 23 May 2018 10:29:22 GMT

Is your EG running on a Unix server? All I can think of is your install/run area are different, and one or the other is lacking in the necessary conversion software. If it runs on a Unix server which doesn't have Office and doesn't have PCFiles server, then you need to get pcfiles server installed and setup.

Maybe someone else here can provide something more specific.

Re: Why am i unable to see the export to .mbd file?

Kurt_Bremser — Wed, 23 May 2018 10:46:15 GMT

Since you only have the "modern" xlsx Format available (which is openly documented and consists of a bunch of xml files in a zip archive), I guess you are lacking the necessary module from Microsoft that is needed to create the older Office formats (xls and mdb).

Have your EG installation checked for this. (in EG, Help - Configuration, look for MDAC version)

As a quick workaround, I suggest you export to a csv file and import that into Access.

Re: Why am i unable to see the export to .mbd file?

CaseySmith — Fri, 25 May 2018 14:12:32 GMT

I wanted to add...

I suspect you are using 64-bit EG. EG uses the Microsoft Jet Engine provider to write to the .mdb format. The Microsoft Jet Engine is 32-bit only, thus only works in 32-bit EG, thus exporting to .mdb (via the client UI) is only available in 32-bit EG.

EG's system requirements doc has this note:

"Note: On 64-bit operating systems, SAS recommends using the 32-bit version of SAS Enterprise Guide for greater compatibility with data providers. See reference, SAS Deployment Wizard and SAS Deployment Manager 9.4 User's Guide.pdf for more information."

Related, but applies to import rather than export... in the EG help (Help->SAS Enterprise Guide Help), the "Working with Data: File types that SAS Enterprise Guide reads and writes" topic has this note:

"In the 64-bit version of SAS Enterprise Guide, you can import Microsoft Access files (*.mdb, *.accdb) only if the 64-bit version of Microsoft Access or the 64-bit version of the Microsoft Office System (ACE) Driver is installed. Similarly, if you are running the 32-bit version of SAS Enterprise Guide, then you must have the 32-bit version of Microsoft Access or the Microsoft Office System (ACE) Driver in order to import Microsoft Access files."

Note: The comments above apply to the client, when the client is performing the import or export (rather than SAS code on the server). The server (ex. processing proc import and proc export) has different, but similar requirements. See proc import/export doc for those.

Casey

Re: Why am i unable to see the export to .mbd file?

Mark5 — Mon, 28 May 2018 05:12:39 GMT

Thank you for the reply, this explains a lot,