you can use data step to merge one to many.
but proc sql for many to many

data test1;
input a b c;
datalines;
1 2 1
13 9 1
1 2 2
;
run;
data test2;
input c d e;
datalines;
1 7 3
1 19 12
3 4 5
;
run;

proc sql;
create table test3 as
select test1.*, d, e
from test1, test2
where test1.c=test2.c;
quit;

楼上说的不错，学习了

产生笛卡儿 还是用sql比较方便

2# sdu0632

本人是初学者，刚看到你的回复贴子，有些不太明白，可否解释下，谢谢

2# sdu0632

哦，我晓得了