Date:         Thu, 5 Aug 1999 00:44:50 +1000
Reply-To:     Chris Latham & Natalie Myers <chrisnat@OZEMAIL.COM.AU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Chris Latham & Natalie Myers <chrisnat@OZEMAIL.COM.AU>
Subject:      Re: Help : Building / determining org structure from jumbled data
Content-Type: text/plain; charset=us-ascii

Folks,

After a couple of off-list replies (thanks Michael Bramley, Bill
Kastner),
it seems that I didn't make myself too clear.......

The example data I gave was just that - an example.
(please don't think I would try and do something that small with SAS ;-)
)

- The actual Org data is for 4500 employees (approx)
- There is no standard for the description in Position
  (so I can't just sort it or assign some indicator value)
- There are duplicate positions ie Secretary, Supervisor etc

Maybe the problem becomes clearer if I leave position out
of the puzzle and rename the fields....

Jumbled Parent - Child relationship data
   CHILD            PARENT
   A Allan          B Dole
   A Jones          D Man
   A Smith          B Dole
   A Thomas         A Jones
   B Dole           C Link
   C Link           D Man
   D Man            **TOP**
   E Net            B Dole
   ...
   ..
   .

Desired order
   CHILD            PARENT
   D Man            **TOP**
   A Jones          D Man
   A Thomas         A Jones
   C Link           D Man
   B Dole           C Link
   A Smith          B Dole
   E Net            B Dole
   A Allan          B Dole
   ...
   ..
   .


Once again thanks for your help

Chris Latham
Latham Consulting P/L
Sydney, Australia