Date:         Thu, 10 Jul 2003 13:46:35 -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: hierarchical table with SAS

"Bruno Gubler" <bruno.gubler@amazit.ch> wrote in message
news:ade981f0.0307100020.1513ac03@posting.google.com...
> Hi Everyone,
>
> I would like to make a Query on hierarchical table with SAS, which
> gives me back all follow of top-father "700" and there
> hierarchy-level.
>


SAS has an example you might use for a starting point.
Under your sas installation folder, look in folder core/sample/ for file
sqlfun01.sas
...
TITLE: Demonstrates Recursive Joins with PROC SQL
...
 * notes: this is an example of fishing out a "bill-of-materials"
 *        type parts implosion using sql. The data are modelled
 ...
--
Richard A. DeVenezia, http://www.devenezia.com