Is it possible to make a full joins with the use of hash object? the result to be obtained is the following (with proc sql):
data tab1;
input var1 value;
datalines;
1 11
1 11
2 22
3 33
9 88
run;
data tab2;
input var1 value;
datalines;
1 11
2 22
3 99
4 999
run;
PROC SQL;
create table tab_fullj as
select A.var1 as A_var1 ,
B.var1 as B_var1 ,
A.value as A_value,
B.value as B_value ,
COALESCE (A.var1,b.var1) as coal_var1,
COALESCE (A.value,b.value) as coal_value
from
tab2 as A
full join
tab1 as B
on a.var1=b.var1;
quit;
... View more
