Date:         Fri, 11 Feb 2011 11:29:50 -0800
Reply-To:     Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Jack Hamilton <jfh@STANFORDALUMNI.ORG>
Subject:      Re: Org charts with SAS?
Comments: To: "DUELL, BOB (ATTCINW)" <BD9439@ATT.COM>
In-Reply-To:  <331C5406E0EC64408B07D6B74516BE1713160F7D@BD01MSXMB018.US.Cingular.Net>
Content-Type: text/plain; charset=us-ascii

I haven't used it myself, but if you have SAS/OR you could use PROC NETDRAW:

   http://support.sas.com/onlinedoc/913/getDoc/en/orpmug.hlp/netdraw_sect41.htm


On Feb 11, 2011, at 10:16 AM, DUELL, BOB (ATTCINW) wrote:

> 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