topic Re: Export to Access in Linux in SAS Procedures

Export to Access in Linux

Lu2017 — Wed, 15 Mar 2017 15:18:51 GMT

Hi,

I use SAS EG 7.1 (64-bits) on Linux. I want to export SAS table in ACCESS. How can i do?

I tried many code, but all doesn't work.

Example 1 :

proc export data=table_test

outtable='test'

DBMS=access replace;

database="&FileSource.\test.accdb";

run;

ERROR: DBMS type ACCESS not valid for export.

Example 2:

proc export data=table_test

outtable='test'

DBMS=accesscs replace;

database="&FileSource.\test.accdb";

run;

ERROR: Server Name is invalid or missing.

Thanks

Kurt_Bremser — Wed, 15 Mar 2017 15:23:53 GMT

dbms=access is only available on Windows, as it uses a Windows-only module supplied by Microsoft.

dbms=accescs uses the PC Files Server, which must be installed on a Windows machine with Office.

The best method to communicate with third-party software is to use a textual format that the target application understands, like csv.

No additional modules or licenses needed, a simple data step does the export, and the transfer file can be inspected with a simple text editor.