topic Re: Exporting SAS Tables to MS Access in Unix in SAS Enterprise Guide

Exporting SAS Tables to MS Access in Unix

deleted_user — Tue, 31 Oct 2006 21:56:07 GMT

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.

Re: Exporting SAS Tables to MS Access in Unix

Olivier — Thu, 02 Nov 2006 12:32:30 GMT

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.

Re: Exporting SAS Tables to MS Access in Unix

deleted_user — Mon, 06 Nov 2006 14:08:28 GMT

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.

Re: Exporting SAS Tables to MS Access in Unix

Olivier — Tue, 07 Nov 2006 09:24:52 GMT

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.