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
In-Reply-To:  <66950c$knu$1@flood.weeg.uiowa.edu>
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).