From > To A > B B > C B > D C > B C > E From To1 To2 To3 To4 etc. A > B C D E B > C D E C > B E so i am trying to find all linked nodes in the above example. how would i do that in SQL or SQL within SAS. basically the same thing. all i want to do is find all linked nodes to the original node. > is the direction. 1st column is the From node, To is the destination node. You can name it to To1, To2 etc.. Must be able to handle more than just the example. Thanks a bunch.
From To1 To2 To3 To4 etc. A > B C D E B > C D E C > B D E updated C line, should be B D E, not just D E.
