Date:         Wed, 15 Nov 2000 16:57:46 -0700
Reply-To:     Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <JackHamilton@FIRSTHEALTH.COM>
Subject:      Re: Converting SAS to MS Access97
Comments: To: Gregory.John.Toland@CENSUS.GOV
Content-Type: text/plain; charset=us-ascii

I am assume you mean SAS for Windows.

The easiest way would be to use the SAS ODBC driver to set up
an ODBC data source, and then just import it from Access.

Or, if you have SAS/Access to ODBC, you could use PROC ACCESS
(or, in version 8, a libname statement) to write an MDB from
SAS.

Or, if you have SAS/Access for OLE (whatever the product is
called), you could do the same thing, using OLE instead of ODBC.

Or, you could use a third-party product such as DBMS/COPY, which
can read a SAS dataset and write a Jet database.

Or, if you have time but not money, you could write a SAS program
which would write raw SQL (CREATE TABLE and INSERT statements),
and then read them in an Access/VBA program.  I actually did that
years ago when other options weren't available.

Or, if you have even more time, you could write an Access VBA
program to read a SAS transport dataset, which is in a public
format.

Or, if you're in a learning mode, and have SAS version 8, the
most recent ADO, and Internet Explorer 5, you could use SAS to
write your data in the OIMDBM XML format, write some XSLT to
convert that to ADO's XML format, then read the result into
a disconnected ADO recordset.  I'm not sure how to convert a
disconnected recordset to a database, but I'm sure it's possible.



--
JackHamilton@FirstHealth.com
Development Manager, Technical Group
METRICS Department, First Health
West Sacramento, California USA


>>> <Gregory.John.Toland@CENSUS.GOV> 11/15/2000 3:16 PM >>>
What is the best way to convert SAS datasets to MSAccess97?  Is it even
possible?  I searched the SAS web site and was not able to find much.  Any help
would be great!

Greg