find out grandson

[aanan1417]

data have;
input father $ son $;
cards;
a  b

b  c

c  d

d  e
;
run;

data want;
input grandfather$  father $ son $;
cards;
a  b   c

b  c   d

c  d   e;
run;

[FreelanceReinh · Accepted solution]

Hello @aanan1417,

Try this:

proc sql;
create table want as
select a.father as grandfather, a.son as father, b.son
from have a, have b
where a.son=b.father
order by 1, 2, 3;
quit;

[aanan1417]

thanks a ton

[PeterClemmensen]

There was a similar thread not long ago. You may find suitable code there.

https://communities.sas.com/t5/SAS-Programming/How-to-find-great-grand-parents-in-the-dataset/m-p/72...