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?
Content-Type: text/plain; charset="us-ascii"
Does anyone have sample programs on creating simple org charts using
SAS? I have data similar to the following:
input @1 user_id $6. @8 name $10. @19 supervisor_id $6.;
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
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