Desktop productivity for business analysts and programmers

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

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

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

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


Accepted Solutions
Solution
a month ago
Super User
Posts: 9,886

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code

View solution in original post


All Replies
Super User
Super User
Posts: 9,409

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

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

 

New Contributor
Posts: 4

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

Hi

 

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

Super User
Super User
Posts: 9,409

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

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#p1d0tocg3njhmfn1d4...

 

accesscs is trying to use pcfiles. 

New Contributor
Posts: 4

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

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.

Super User
Super User
Posts: 9,409

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

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.

Solution
a month ago
Super User
Posts: 9,886

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

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.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
SAS Super FREQ
Posts: 391

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

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

New Contributor
Posts: 4

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

Posted in reply to CaseySmith

Thank you for the reply, this explains a lot,

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 8 replies
  • 259 views
  • 1 like
  • 4 in conversation