Date:         Mon, 13 Dec 2004 15:52:50 -0800
Reply-To:     "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:      Re: Reading ACCESS files
Comments: To: Peter Flom <flom@NDRI.ORG>

Peter -

If you have SASv9 then you'll want to try the access libname engine.  As
long as there's a target database you can read files in and out, append data
to tables and delete tables...It doesn't edit "in place" but otherwise it's
about as SAS-like as it can get.

Create a blank database named "new.mdb" in your default directory and try
this:

libname acctb access  'new.mdb';

DATA acctb.new;
     SET sashelp.class;
run; /* write a file */

DATA new;
     SET acctb.new;
run; /* read a file */

proc append base=acctb.new data=new ;
run; /* add some data */

proc delete data=acctb.new;
run; /* erase data */

libname acctb clear;

See "Accessing PC Files Data with the LIBNAME Statement" in the online doc.

hope that helps -

Paul Choate
DDS Data Extraction
(916) 654-2160

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Peter
Flom
Sent: Monday, December 13, 2004 5:32 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Reading ACCESS files

Hello again

As part of the same meta-analysis I wote about last week, we are hiring
someone to work with us designing a database in Microsoft ACCESS.  She
knows a lot about ACCESS, but nothing about SAS.  I know a smattering of
SAS, but nothing about ACCESS.

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

Any hints or pointers to the appropriate manuals will be appreciated,

Thanks

Peter

Peter L. Flom, PhD
Assistant Director, Statistics and Data Analysis Core
Center for Drug Use and HIV Research
National Development and Research Institutes
71 W. 23rd St
www.peterflom.com
New York, NY 10010
(212) 845-4485 (voice)
(917) 438-0894 (fax)