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
ERROR: DBMS type ACCESS not valid for export.
ERROR: Server Name is invalid or missing.
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.
Time is running out to save with the early bird rate. Register by Friday, March 1 for just $695 - $100 off the standard rate.
Check out the agenda and get ready for a jam-packed event featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
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.
Select SAS Training centers are offering in-person courses. View upcoming courses for:
View all other training opportunities.