Date: Tue, 27 Jun 2000 08:55:15 -0700
Reply-To: Steve Spurling <sspurlin@CCSF.CC.CA.US>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Steve Spurling <sspurlin@CCSF.CC.CA.US>
Organization: City College of San Francisco
Subject: Re: SAS vs Access
Content-Type: text/plain; charset=us-ascii
As it happens, I just took a class in Access and was impressed by this
microsoft product. I am currently both exporting SAS datasets to Access and
linking SAS and Access together through OLEDB. That allows me to run
statistical analyses directly from the Access database rather than having to
import them into a SAS format.
The advantage of SAS is that it has a number of statistical analysis
techniques tied to it. These are both impressive and numerous. They are
impressive both because of their many features and because of the speed at which
they run. SAS is general is quite fast. SAS also has the ability to handle as
many records as you might find in Access. I have used it with million record
files without difficulty (though the processing does slow down). The only
downside is error checking and entry validation. You can do that in SAS but you
have to write your own programs to do that. Since SAS is different from other
programming languages, it takes a bit of time to learn how to do this. Access
has easier facility to deal with data entry with validation rules and its
interfaces to the data enterer and simple queries of the database. So, the
main reason in my view to acquire SAS is for the statistical analysis. Do you
have people who need this facility at your place of work?
Researcher, City College of San Francisco
> Hi, we are looking at getting SAS for our department, and I have a few
> questions maybe someone can answer for me.
> 1. How does SAS differ from Access, aside from the fact that one is a
> database and one is a tool for analysis. Basically what I am trying to
> do is show everyone the basic differences and why we need BOTH Access
> and SAS.
> 2. While using SAS, if we use the data pulled directly from Access,
> does SAS have the capability to filter out errors that already may
> exist in the database. Basically what are it's limitations on
> analyzing data. For example, does the data have to come over from
> Access a certain way for SAS to successfully compute a statistical
> analysis of it.
> 3. If the data is already erroneous is Access or the main txt file,
> will it not be wrong in SAS as well?
> 4. Does anyone know the maximum records SAS will store? I think my
> main database has over 200,000 records.
> Thank you all!!!
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!