Date:         Fri, 11 Feb 2011 15:18:05 -0500
Reply-To:     Richard DeVenezia <rdevenezia@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Richard DeVenezia <rdevenezia@GMAIL.COM>
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=ISO-8859-1

Hi Bob:

You might consider writing SAS code to output html that uses Google Chart Tools.
See http://code.google.com/apis/visualization/documentation/gallery/orgchart.html

Richard A. DeVenezia
http://www.devenezia.com

On Fri, Feb 11, 2011 at 1:16 PM, DUELL, BOB (ATTCINW) <BD9439@att.com> 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