Date: Wed, 10 Mar 1999 12:11:01 +0530
Reply-To: "Mohanty, Debasmit (CAP)" <Debasmit.Mohanty@GEIND.GE.COM>
Sender: "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From: "Mohanty, Debasmit (CAP)" <Debasmit.Mohanty@GEIND.GE.COM>
Subject: Re: SAS vs. Oracle
Content-Type: text/plain; charset="iso-8859-1"
You have mainly talked about 2 issues:
1. Merging large datasets
- Here you should try to leverage on the strength of Oracle. Since the
Oracle database would have indexes / partitioned indexes for all the joining
keys, merging would be faster in Oracle compared to that in SAS.
2. Deriving variables on complex criteria
- For this, I would say SAS is better as it has lot more flexibility
than in Oracle.
To summarize, I would say one should do the DATA PREPARATION activities (
querying / joining / filtering/ summarization ) in Oracle
Where as use SAS for all DATA TRANSFORMATION activities (derived variables
Any other thoughts ?
g GE Capital
Debasmit SR Mohanty
Assistant Manager - Systems
GE Capital Card Services - I M
A-1, Golden Enclave, Airport Road,
Bangalore - 560 017, India
Phone : +91-80-527 5535 Ext 107
Mobile : +91-98440-25340
Fax : +91-80-527 5930
Internet : Debasmit.Mohanty@geind.ge.com
URL : http://www.angelfire.com/me/debasmit/
Disclaimer: The opinion herein expressed are of mine and
Doesn't reflect that of my employer
From: Jesse Chittams [SMTP:jchittam@CCEB.UPENN.EDU]
Sent: Wednesday, March 10, 1999 2:05 AM
Subject: SAS vs. Oracle
Has anyone compared SAS and Oracle on UNIX regarding, merging large
sets (millions of records and hundreds of variables), and deriving
variables base on complex criteria?