Date: Fri, 12 Aug 2005 07:45:38 -0400
Reply-To: "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: "Richard A. DeVenezia" <radevenz@IX.NETCOM.COM>
Subject: Re: Do you think sas programmers should only use sas?
Michael Murff wrote:
> As a related question, I would be interested in hearing of task that
> are impossible (or at least impractical) with a SAS tool? Any takers?
Dealing with certain data constructs that require recursive joins to flatten
or 'get to the bottom'. One arena is Bill of Materials (BOM) expansion.
While doable in SAS, it's not the prettiest or most efficient. See
http://five.pairlist.net/pipermail/oracle-article/2003/000002.html for some
talk of Oracle's STARTING and CONNECTING SQL clauses.
Richard A. DeVenezia