topic find out grandson in SAS Programming

find out grandson

aanan1417 — Fri, 21 May 2021 07:36:32 GMT

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;

Re: find out grandson

FreelanceReinh — Fri, 21 May 2021 08:18:09 GMT

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;

Re: find out grandson

PeterClemmensen — Fri, 21 May 2021 09:20:42 GMT

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/726480

Re: find out grandson

aanan1417 — Fri, 21 May 2021 09:24:04 GMT

thanks a ton