| Date: | Sat, 12 Feb 2011 02:17:54 +0800 |
| Reply-To: | Murphy Choy <goladin@GMAIL.COM> |
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
| From: | Murphy Choy <goladin@GMAIL.COM> |
| Subject: | Re: Org charts with SAS? |
|
| In-Reply-To: | <331C5406E0EC64408B07D6B74516BE1713160F7D@BD01MSXMB018.US.Cingular.Net> |
| Content-Type: | text/plain; charset=ISO-8859-1 |
|---|
Hi,
One of Phil Holland's paper talks about this. Maybe you want to have a look
at his papers.
On Sat, Feb 12, 2011 at 2:16 AM, 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
>
--
Regards,
Murphy Choy
Certified Advanced Programmer for SAS V9
Certified Basic Programmer for SAS V9
DataShaping Certified SAS Professional
|