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"
Jesse:
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
etc )
Any other thoughts ?
-Debasmit
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/
<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
To: SAS-L@UGA.CC.UGA.EDU
Subject: SAS vs. Oracle
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
| 
