什么唯一不唯一,对应关系如何,想要别人帮你至少先自己理清思路。作者: shiyiming 时间: 2009-1-4 18:49 标题: Re: 请大家帮帮忙,初学者,谢谢了,在线等! [code:2bqonoxr]
/*程序没调试过,楼主可以自己去调试一下*/
proc sort data=a;
by name mobile;
run;
proc sort data=b;
by name mobile;
run;
data a1 a2;
set a;
if first.name+last.name=2 then output a1;
else output a2;
run;
data result;
merge a1 b(in=ok);
by name;
if ok;
run;
/*假设你这里是1对多的情况,如果是多对多,就用sql*/
data result;
merge a2 result(in=ok);
by name mobile;
if ok;
run;[/code:2bqonoxr]