topic Re: SAS EG 7.1 - Export to .mdb by code (Unix Server) in SAS Enterprise Guide

SAS EG 7.1 - Export to .mdb by code (Unix Server)

MariaD — Fri, 05 Oct 2018 19:52:40 GMT

Hi folks,

We have EG 7.1 64 bits connecting with our Unix server (SAS 9.4 M5). I know that you can export to .mdb using point-and-click options if you have Office 64 bits installed or Microsoft ACE 64-bits. We have license PC Files but we don't have it configure in a Windows machine. So, there is any way to export, using programming, to .mdb? For example, for Microsoft Excel exists the option to "export" using ODS Excel.

Regards,

Re: SAS EG 7.1 - Export to .mdb by code (Unix Server)

jebjur — Fri, 05 Oct 2018 20:19:05 GMT

If you want to export to MS Access from SAS \ Eguide using code, then you can use PROC EXPORT if you license SAS/Access to PC Files on the SAS server and you also install a piece of software called PC Files Server on a network PC. The documentation for PC Files Server (including examples of the code you would use) can be found here:

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

In this example, you export data from the SAS data set WORK.SASCUSTOMERS to create a new table, Customers_2, which is located on same Windows machine as the SAS PC Files Server.

PROC EXPORT DATA=WORK.SASCUSTOMERS
     OUTTABLE='Customers_2'
     DBMS=ACCESSCS REPLACE ;
     DATABASE='mydrive:\yourAccessdirectory\AnnualFiles.accdb'; 
     SERVER='myPCFServer.com';
     PORT=9621;
     DBDSOPTS='INSERTBUFF=15';
 RUN;

Re: SAS EG 7.1 - Export to .mdb by code (Unix Server)

MariaD — Fri, 05 Oct 2018 20:43:28 GMT

Thanks, we have PC Files licensed. Is it possible to install PC File Server on every client computer in addition to SAS EG? Or only in one Windows computer?

Re: SAS EG 7.1 - Export to .mdb by code (Unix Server)

SASKiwi — Fri, 05 Oct 2018 22:03:52 GMT

The Windows machine you install the SAS PC File Server on needs to be accessible from your SAS Unix server, including the port you will use to communicate (often controlled by firewall rules). For that reason it may be easier to share a single machine. At least that way the SAS code you use would be the same for all users - same server name and port number.

Re: SAS EG 7.1 - Export to .mdb by code (Unix Server)

MariaD — Mon, 08 Oct 2018 11:56:18 GMT

Thanks @SASKiwi. One last question. The path where the file will be create is on Windows (where PCFF is installed or visible through network)? Or is it possible to define a path on my SAS Unix server too?

Re: SAS EG 7.1 - Export to .mdb by code (Unix Server)

SASKiwi — Mon, 08 Oct 2018 18:56:50 GMT

The path can be anywhere that the SAS PC File Server recognises. If it is on your SAS Unix server then a folder share would need to be created on Unix and accessible from Windows.