Solved: find out grandson

aanan1417 · Posted 05-21-2021 03:36 AM

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 · Posted 05-21-2021 04:18 AM

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;

View solution in original post

FreelanceReinh · Posted 05-21-2021 04:18 AM

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;