Date:         Wed, 30 May 2001 11:42:05 -0400
Reply-To:     "Muhlbaier, Lawrence H." <lawrence.muhlbaier@DUKE.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Muhlbaier, Lawrence H." <lawrence.muhlbaier@DUKE.EDU>
Organization: Duke Clinical Research Institute
Subject:      Re: remote access from sas to access
Content-Type: text/plain; charset=us-ascii

I can tell you in theory; I haven't done it.  First, you must be running
SAS V8.x  on the Unix system.

You need two 'additional' things on the Unix system:  the SAS/Access to
ODBC product, and an ODBC connectivity package for Unix.

Then you can use all the SAS/Access tools to get to Microsoft Access on
the PC.  The syntax is in the documentation for SAS/Access.

Doc
-----------------------------------
kin tang wrote:

> Hello,
>
> Is it possible for SAS on a Unix server to run a
> dataset in Access on a PC that does not have SAS
> installed on it? Can someone provide me with a sample
> code to achieve this?
>
> Many thanks.
>
> Kin
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
> http://auctions.yahoo.com/

--
Lawrence H. ('Doc') Muhlbaier           muhlb001@mc.duke.edu
Assistant Research Professor
Duke University Medical Center          919-668-8774 (office)
DUMC 3865                               919-383-0595 (home)
Durham, NC 27710-7510                   919-668-7057 (FAX)