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
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.