Date:         Thu, 5 Nov 1998 10:35:27 -0800
Reply-To:     Robert Mengis <rmengis@BCO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         Robert Mengis <rmengis@BCO.COM>
Subject:      Re: How can I create a MS Access DB using SAS?
Comments: To: "Kagan, Jerry" <KaganJ01@IMSINT.COM>
Content-Type: text/plain; charset="iso-8859-1"

Jerry,
 
I would look at ODBC, although for your volume it won't be very fast either.
I have attached SAS DBs(20,000 rows w/ 15 columns) to MSACCESS in seconds,
but if it is really fat it takes much longer.  I have heard of 100s of
thousand rows with ODBC, but not millions...
   good luck
-----Original Message-----
From: Kagan, Jerry <KaganJ01@IMSINT.COM>
Newsgroups: bit.listserv.sas-l
To: SAS-L@UGA.CC.UGA.EDU <SAS-L@UGA.CC.UGA.EDU>
Date: Thursday, November 05, 1998 8:10 AM
Subject: How can I create a MS Access DB using SAS?
 
 
>Dear SAS Gods, Gurus, etc...  I have a challenge for you:
>
>I need to create MS Access files from SAS data sets (no, a flat file won't
>do).
>
>The files are going to be in the order of  1 - 2 million rows, by about 40
>bytes wide.  Ideally, I would like to run the process on MVS or UNIX
because
>that is where the SAS datasets are being created, and I want to avoid
moving
>them down to a PC and starting a 2nd process (this eventually needs to be a
>one step production process).
>
>I hear that using SAS/ACCESS is very slow to write Access DB files and that
>it doesn't work on MVS or UNIX anyway.  I also don't think I can use DDE
>because it also will not work on MVS or UNIX.
>
>Anyone have any options for me?  Anyone know of any third-party tools to
>create Access DBs on non-wintell platforms?
>
>Thanks for any help!
>-Jerry
>
>---
>Jerry Kagan - kaganj01@IMSINT.com
>IMS Health
>Plymouth Meeting, PA   USA