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?
Content-Type: text/plain; charset="iso-8859-1"
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...
From: Kagan, Jerry <KaganJ01@IMSINT.COM>
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
>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
>that is where the SAS datasets are being created, and I want to avoid
>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 Kagan - kaganj01@IMSINT.com
>Plymouth Meeting, PA USA