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
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
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
Thanks! I will try it! PG
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.