Date: Mon, 8 Dec 1997 15:41:34 +0000
Reply-To: Lauren Haworth 335-6697 <HAWORTHLA@CHR.MTS.KPNW.ORG>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: Lauren Haworth 335-6697 <HAWORTHLA@CHR.MTS.KPNW.ORG>
Subject: Re: MS ACCESS to SAS DATASET
Content-type: TEXT/PLAIN; CHARSET=US-ASCII
There are a couple of options here:
(1) use ODBC and PROC SQL to read the data directly (there are several SUGI
papers on this topic - SUGI 21, I think). Setting up an ODBC connection for SAS
to read Access data is fairly straightforward. The reverse connection (reading
SAS data from Access) is much trickier.
(2) create a .DBF from your Access dataset and use SAS/ACCESS to read your data
(see the SAS/ACCESS documentation).