Desktop productivity for business analysts and programmers

Exporting SAS Tables to MS Access in Unix

Reply
N/A
Posts: 0

Exporting SAS Tables to MS Access in Unix

I'm trying to export a sas table to a new or existing (doesn't matter) MS Access database resident on a Unix box. I can point and click my way through the process successfully (File>Export>Save As...mdb) but need to have the process hard coded so the task can be batch run in the future. EG does not produce a log when I go through the manual step to export so I can't figure out if its using proc export, a libname statement etc. Any ideas??? Thanks.
Super Contributor
Posts: 260

Re: Exporting SAS Tables to MS Access in Unix

I don't think the process uses Proc EXPORT, since you don't have log once you've run it.
The problem is, if you write a program, it will be executed on the Unix box, but unless you have the "PC Files Server" module (or a name that sounds like that), Unix doesn't know you to produce MS Access files.

Identifying the problems don't lead me to a solution, however. I hope it helps anyway.
N/A
Posts: 0

Re: Exporting SAS Tables to MS Access in Unix

Right. This is what SAS support had to say "You cannot use proc export to put a ms access file on unix from a SAS dataset. However, you can use proc export to put a ms access file on the PC from a SAS dataset on Unix using the PC Files Server on the PC. Please let me know if you would like to be able to do this." Thanks for the response.
Super Contributor
Posts: 260

Re: Exporting SAS Tables to MS Access in Unix

It means that if you want to produce files for Access to read them with a program, you will have to go through some text files like tab-delimited or CSV. Maybe there is some "batch import" in MS Access so that you can import several text files in a row ; otherwise some Visual Basic macros may do the trick.
Good luck anyway.
Ask a Question
Discussion stats
  • 3 replies
  • 140 views
  • 0 likes
  • 2 in conversation