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;

Name statements that are execution only.

4 Answers  

Differentiate input and infile.

0 Answers  

How would you code a merge that will keep only the observations that have matches from both sets?

5 Answers  

What are the differences between sum function and using “+” operator?

0 Answers  

What is the size of PDV?

2 Answers   L&T,

What commands are used in the case of including or excluding any specific variables in the data set?

0 Answers  

why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?

2 Answers   Accenture,

What is run-group processing?

0 Answers  

explain the use of % includes a statement in sas? : Sas-administrator

0 Answers  

what is the difference btw proc means and proc univariate?

8 Answers   HSBC, TCS,

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?

2 Answers  

Diff between proc sql merge and join?

1 Answers   HSBC, Sristek,