Date:         Tue, 9 Mar 1999 17:32:25 -0500
Reply-To:     HERMANS1 <HERMANS1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         HERMANS1 <HERMANS1@WESTAT.COM>
Subject:      Re: SAS vs. Oracle
Comments: To: Jesse Chittams <jchittam@CCEB.UPENN.EDU>
Content-Type: text/plain; charset=US-ASCII

I prefer Oracle in situations where you need to define derived variables using a
SQL view of many related tables requiring many indexes.  SAS performs better
where one needs to scan linked tables one record at a time, particularly when
importing data from external files.  SAS also has a much richer collection of
format, informats, and functions than Oracle.  I have a strong preference for
SAS where data sources may not conform at least to the primary key and
referential integrity constraints, or require fuzzy matching on keys.  Sig
____________________Reply Separator____________________
Subject:    SAS vs. Oracle
Author: Jesse Chittams <jchittam@CCEB.UPENN.EDU>
Date:       3/9/99 3:35 PM
 
Hello,
 
Has anyone compared SAS and Oracle on UNIX regarding, merging large data
sets (millions of records and hundreds of variables), and deriving
variables base on complex criteria?
 
Thanks,
-Jesse Chittams