How can I get what I want

[srinivas6640]

Thank you for your help!

Mem_Detail

Parent Child

A B

B C

C D

if you see this dataset mem_detail, A is parent and B is child and in next observation B is parent and C is child so automatically A is grand parent and C is grand child. I want a dataset like Following:

G.Parent G.child

A C

B D

[PGStats · Accepted solution]

Typical problem solved by self-join :

data have;

length parent child $1;

input Parent Child;

datalines;

A B

B C

C D

;

proc sql;

create table want as

select

     P.Parent as Gparent,

     C.child as Gchild

from

     have as P inner join

     have as C on P.child=C.parent;

select * from want;

quit;

PG

[srinivas6640]

Thanks! I will try it! PG