topic Re: How can I get what I want in SAS Programming

How can I get what I want

srinivas6640 — Sun, 26 May 2013 17:18:21 GMT

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

Re: How can I get what I want

PGStats — Sun, 26 May 2013 19:41:32 GMT

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;

Re: How can I get what I want

srinivas6640 — Mon, 27 May 2013 13:35:16 GMT

Thanks! I will try it! PG