data test;
input x y;
cards;
1 2
1 3
1 4
2 3
2 4
2 8
3 4
;
run;
proc sql; create table test_a as select
a.x as x_a, b.x as x_b, a.y
from test as a inner join test as b
on a.y=b.y and a.x<b.x;
quit;
楼主: dengwei715
|
1722
4
[问答] 求助,怎么用merge实现下面sql语句的功能 |
本科生 78%
-
|
本帖被以下文库推荐
| ||
| ||
| ||
| ||
| ||||||||||||||
京ICP备16021002-2号 京B2-20170662号 京公网安备 11010802022788号 论坛法律顾问:王进律师 知识产权保护声明 免责及隐私声明