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.
kin tang wrote:
> 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.
> Do You Yahoo!?
> Yahoo! Auctions - buy the things you want at great prices
Lawrence H. ('Doc') Muhlbaier email@example.com
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)