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
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
libname acctb access 'new.mdb';
run; /* write a file */
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 -
DDS Data Extraction
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Peter
Sent: Monday, December 13, 2004 5:32 AM
Subject: Reading ACCESS files
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,
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
New York, NY 10010
(212) 845-4485 (voice)
(917) 438-0894 (fax)