DATA Step, Macro, Functions and more

expand hierarchy into only two columns

Reply
Regular Contributor
Posts: 163

expand hierarchy into only two columns

I have a parent child table that stores managers and employees respectively. I can get the table to show a child and its direct parent but not the child with every ancestor( parent and grandparent). I want to get it to look like as referenced in here in the Security Associations Table:
http://support.sas.com/documentation/cdl/en/bisecag/61133/HTML/default/a003086341.htm (under
Representations of an Organizational Hierarchy ).
The hierchy is unbalanced and any node can get any deep at any time.
any help?
Ask a Question
Discussion stats
  • 0 replies
  • 152 views
  • 0 likes
  • 1 in conversation