Date: Sat, 18 Nov 2000 00:40:59 -0500
Reply-To: paula <icj808@USWEST.NET>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: paula <icj808@USWEST.NET>
Subject: Re: Converting SAS to MS Access97
I run V8base on NT. I usually export SAS datasets to Access97 or 2000 twice
a week. I have never bothered writing a single line of SAS code to do that.
Just go to Windows Explorer. Double-click the dataset you want to export.
When the dataset is on the screen, go to File menu. See Export there? From
there, follow the Wizard.
One headache doing that is if your SAS dataset is relatively large, say,
1GB+, no matter how fast your chip is, how many GB of memory you have on
your workhorse, expect long time to write to Access. Size also jumps. Also,
I am yet to find an easy way to know for sure that the process is over. I
often click on the Access97 file prematurely and end up inteprepting the
exporting process and have to start all over again.
The nice thing is if you are interested in the code that does the job for
you, you have option to let SAS generate the code for you and save it. This
makes your customization more time-saving.
<Gregory.John.Toland@CENSUS.GOV> wrote in message
> 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
> would be great!