Answer / sumit

Suppose the above dataset name is work.old.
Data new;
Set work.old (first obs = 2);
Run;

Proc sql;
Select Old.parent as grandfather, Old. Child as father,
new.child as grandchild from work.Old as old, work.new as
new
where old.child = new.parent;
quit;

Answer / guest

data dx;
infile datalines dsd dlm=',';
input parent :$8. child :$8.;
datalines;
A,B
B,C
D,E
F,G
G,H
H,I
;;;;
run;

data dy(rename=(parent=grandfather child=father)) ;
merge dx(firstobs=2 in =a rename=(child=grandchild
parent=child ))
dx(firstobs=1 in =b );
by child;
if a and b;
run;
proc print;
var grandfather father grandchild;
run;

Answer / altumish

A simple self Join:

data old;
input Parent $ Child $;
cards;
A B
B C
D E
F G
G H
H I
I J
J K
J L
P S
;

Proc sql;
Select Old.parent as grandfather, Old.Child as father,
new.child as grandchild from work.Old as old, work.Old as new
where old.child = new.parent;
quit;

Answer / jayant

data tet;
input par $ child $;
datalines;
A B
B C
C D
E F
;
run;




data tet1;
set tet;
grand=lag(par);
drop par;
run;

Answer / sas@freek

data family;
input parent $ child $;
datalines;
A B
B C
C D
D E
E F
F G
G H
H I
;
run;
data family_new(drop=parent child);
set family;
parent1=lag(parent);
child1=lag(child);
grand_child=child;
if _n_ ge 2;
run;

proc print data=family_new;
var parent1 grand_child;
run;

Differentiate input and infile.

0 Answers  

How to read multiple excel sheets from a single excel file at once????

7 Answers   HCL, Verinon Technology Solutions,

What is the significance of the ‘OF’ in X=SUM (OF a1-a4, a6, a9);?

8 Answers  

How do you add a number to a macro variable?

3 Answers  

What is SAS?

0 Answers  

Mention common programming errors committed in sas ?

0 Answers  

What are the automatic variables for macro? : sas-macro

0 Answers  

Which are SAS Windows Clients & SAS Java Clients

3 Answers   TCS,

Can you continue to write code while the rest of the people on the floor where you work have a noisy party to which you were not invited?

2 Answers   Oracle,

what can you learn from the sas log when debugging? : Sas programming

0 Answers  

for whom is sas data integration studio designed? : Sas-di

0 Answers  

what is PhaseIII, ODS, TLG, Macro and Proc in SAS

0 Answers