Help using Base SAS procedures

Export to Access in Linux

Reply
Regular Learner
Posts: 1

Export to Access in Linux

[ Edited ]

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

Super User
Posts: 7,863

Re: Export to Access in Linux

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.

 

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 252 views
  • 0 likes
  • 2 in conversation