Date:         Mon, 13 Dec 2004 10:00:42 -0500
Reply-To:     Jerry Davis <jwd@GRIFFIN.UGA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jerry Davis <jwd@GRIFFIN.UGA.EDU>
Subject:      Re: Reading ACCESS files
In-Reply-To:  <s1bd5383.026@MAIL.NDRI.ORG>
Content-Type: text/plain; charset="US-ASCII"

Peter Flom wrote:

> What do she and I need to know so that we can make this work?
> Can we read the ACCESS files using Base SAS?

I have access to SAS for PC file formats and this snippet of code works
for me.

proc import table="dummy1" out=sasfiles.dummy1 dbms=access;
             database="c:\sas\various\dummy.mdb";

* dummy.mdb is the database name;
* dummy1 is the internal table name;

data one;
   set sasfiles.dummy;
proc print;
...

Jerry
--
Jerry Davis
Experimental Statistics
UGA, CAES, Griffin Campus