data a;
input num r;
cards;
1 1
1 2
2 1
2 2
3 1
3 2
;
run;
data b;
input r m;
cards;
1 0.1
2 0.2
;
run;
data need;
merge a b;
by r;
run;
proc print data=need;
run;
data a;
input num r;
cards;
1 1
1 2
2 1
2 2
3 1
3 2
;
run;
data b;
input r m;
cards;
1 0.1
2 0.2
;
run;
proc sql;
create table need as
select a.num,
a.r,
b.m
from a as a
full join b as b
on a.r=b.r
order by num, r;
quit;