Hello fellow SAS EG users. I need to run a parent child where each parent and each child have a separate row, with the complete pedigree for each row. The sample attached is a more visual aspect using the British royal family as samples. I've used left outer joins from each sub-table, but that leaves me with the rows highlighted in salmon missing. Any idea how to get those extra rows, so that I get 1 row per family member whether it has descendants or not. (the sequence number isn't used here, but it helps sort the table adequately in the end by level). Thank you very much. Chip1963 from Ottawa Canada (Same as excel file attached)
... View more