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" <firstname.lastname@example.org> wrote in message
> 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
SAS has an example you might use for a starting point.
Under your sas installation folder, look in folder core/sample/ for file
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