https://communities.sas.com/t5/ODS-and-Base-Reporting/Problem-getting-data-quot-depth-level-quot/m-p/6331#M2498 I ahve a dataset consisting of 9000+ staff members for which I have their staff ID and their manager's staff ID. I want to be able to generate the "depth" down the staff tree for these users (eg there are four upward hops from me to the Group Chairman so I have a depth of four). In addition I want to associate each staff member with their uber-manager (ie with a depth of one).<BR /> <BR /> Both problems seem to call for some sort of tre-walk macro but it's outwith my experience to write one and nothin on the SAS website seems to address the issue. Closest I've seen is SUGI paper 87-28 but that's walking down an existing structure rather than up a virtual one.<BR /> <BR /> Anyone seen anything like this before?<BR /> <BR /> AxS Fri, 11 Jan 2008 10:17:02 GMT AxS 2008-01-11T10:17:02Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Problem-getting-data-quot-depth-level-quot/m-p/6331#M2498 I ahve a dataset consisting of 9000+ staff members for which I have their staff ID and their manager's staff ID. I want to be able to generate the "depth" down the staff tree for these users (eg there are four upward hops from me to the Group Chairman so I have a depth of four). In addition I want to associate each staff member with their uber-manager (ie with a depth of one).<BR /> <BR /> Both problems seem to call for some sort of tre-walk macro but it's outwith my experience to write one and nothin on the SAS website seems to address the issue. Closest I've seen is SUGI paper 87-28 but that's walking down an existing structure rather than up a virtual one.<BR /> <BR /> Anyone seen anything like this before?<BR /> <BR /> AxS Fri, 11 Jan 2008 10:17:02 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Problem-getting-data-quot-depth-level-quot/m-p/6331#M2498 AxS 2008-01-11T10:17:02Z https://communities.sas.com/t5/ODS-and-Base-Reporting/Problem-getting-data-quot-depth-level-quot/m-p/6332#M2499 sounds like a good casebook example for the data step hash object. <BR /> There will be some excellent examples among the SAS Samples : Go to <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> and navigate (left hand side) in "Knowledge Base" to "Samples &amp; SAS Notes"<BR /> <BR /> Good Luck<BR /> <BR /> PeterC Fri, 11 Jan 2008 11:46:25 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Problem-getting-data-quot-depth-level-quot/m-p/6332#M2499 deleted_user 2008-01-11T11:46:25Z