Path: text.usenetserver.com!out04b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!feeder.news-service.com!feeder1.cambrium.nl!feed.tweaknews.nl!138.199.65.86.MISMATCH!sn-xt-ams-06!sn-xt-ams-04!sn-ams!sn-feed-ams-02!sn-post-ams-02!sn-post-ams-01!sn-post-sjc-02!sn-post-sjc-01!supernews.com!corp.supernews.com!news.victoria.tc.ca!vtn1!yf110
From: yf110@vtn1.victoria.tc.ca (Malcolm Dew-Jones)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Does Oracle have a SAS datastep?
Date: 7 Nov 2007 21:04:27 -0800
Organization: Victoria Telecommunity Network
Message-ID: <473298db$1@news.victoria.tc.ca>
References: <1194460790.327995.145070@k79g2000hse.googlegroups.com>
X-Newsreader: TIN [version 1.2 PL2]
X-Original-NNTP-Posting-Host: 199.60.222.3
X-Original-Trace: 7 Nov 2007 21:04:27 -0800, 199.60.222.3
XPident: yf110
X-Complaints-To: abuse@supernews.com
Lines: 16
Xref: usenetserver.com comp.databases.oracle.misc:250525
X-Received-Date: Thu, 08 Nov 2007 00:04:51 EST (text.usenetserver.com)

Robert (irishhacker@gmail.com) wrote:

: Does Oracle have anything comparable to the data transformation
: procedures in SAS/BASE? In particular, the SAS datastep? ( SAS/BASE is

Yes, SQL (I'm serious).

I recall a really long involved SAS program I had to convert.

After reverse engineering it, and analysing what it was realy trying to
accomplish (took a few days for sure), then I was able to write the
equivalent logic with a couple of group-by SQL statements.

I guess if all you're doing is feeding data into the statistical packages 
then it might be harder to reproduce the results.