Date:         Mon, 13 Dec 2004 20:42:51 +0530
Reply-To:     Bhavani Shankar <bhavani.shankar@INDIA.BIRLASOFT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bhavani Shankar <bhavani.shankar@INDIA.BIRLASOFT.COM>
Subject:      Re: Reading ACCESS files
Comments: To: Jerry Davis <jwd@GRIFFIN.UGA.EDU>
Content-Type: text/plain; charset=iso-8859-1

Hi Jerry
         They don't have SAS Access for PC File Formats. They can't use Proc
Import or Proc Export. My suggestion is
First of all you need to export an Access MDB file to a text file (say
csv,txt or any other text format) using the EXPORT option in the FILE
menu.
Then you will have to read the TEXT file using Base SAS.
Any further suggestion will help them.
Thanks
Bhavani

-----Original Message-----
From: Jerry Davis [mailto:jwd@GRIFFIN.UGA.EDU]
Sent: Monday, December 13, 2004 8:31 PM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Reading ACCESS files


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
Disclaimer: 'This email and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they are
addressed. If you have received this email in error please notify the system
manager. Please note that any views or opinions presented in this email are
solely those of the author and do not necessarily represent those of the
company. Finally, the recipient should check this email and any attachments
for the presence of viruses. The company accepts no liability for any damage
caused by any virus transmitted by this email.'