Date:         Fri, 11 Feb 2011 10:16:21 -0800
Reply-To:     "DUELL, BOB (ATTCINW)" <BD9439@ATT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "DUELL, BOB (ATTCINW)" <BD9439@ATT.COM>
Subject:      Org charts with SAS?
In-Reply-To:  <01384B2401936142AF5F65E3D1240278093D6F2D@EX3VS1.nyced.org>
Content-Type: text/plain; charset="us-ascii"

Hi,

Does anyone have sample programs on creating simple org charts using
SAS?  I have data similar to the following:

data have;
  input @1 user_id $6. @8 name $10. @19 supervisor_id $6.;
  datalines;
td1000 Top Dog    td1000
as1000 Amy Asst   td1000
jm1000 Joe Mgr    td1000
mm1000 Mary Mgr   td1000
bd1000 Bob Pgmr   jm1000
bp1000 Bilbo Pgmr jm1000
sp1000 Sue Pgmr   jm1000
jp1000 Jim Pgmr   mm1000
kp1000 Karen Pgmr mm1000
run;

The "top dog" has user_id=supervisor_id; only one record is so marked.

I have Base SAS and SAS/GRAPH.  I also have AF and am aware of the "org
chart" object, but it's been a very lng time since I've used AF and I'm
hoping not to have to go down that road.  I also have the "Add-in for
Microsoft Office", although I've never used that either. Any clever
ideas?

TIA,

Bob