a****g 发帖数: 8131 | 1 Find the solution.
比如我有
1
2
2
3
希望找出1和3
或者找出有duplicate的数值
哪个简单用哪个
thanks |
x**m 发帖数: 941 | 2 Using:
first.xx=last.xx then delete;
you will get the number with duplicates. |
j*******9 发帖数: 27 | 3 你用什么软件?sql里面好像可以用distinguish, unique。。。非常不肯定... |
a****g 发帖数: 8131 | 4 you mean 'distinct'? it will pick one from duplicates, not separate them
【在 j*******9 的大作中提到】 : 你用什么软件?sql里面好像可以用distinguish, unique。。。非常不肯定...
|
a****g 发帖数: 8131 | 5 I think yours will not work
here is what I found
data a1;
set a2;
by vars...;
if ^first.var;
run;
very easy and efficient
【在 x**m 的大作中提到】 : Using: : first.xx=last.xx then delete; : you will get the number with duplicates.
|
k*******a 发帖数: 772 | 6 sql version:
data a;
input x;
datalines;
1
2
2
3
;run;
proc sql;
select a.*
from a as a, a as b
where a.x=b.x
group by a.x
having count(*)=1
; |
a********a 发帖数: 346 | 7 I simplified code:
proc sql;
select x
from a
group by x
having count(x)=1
; |
l*****e 发帖数: 12 | 8 proc sort data=XXX out=nodup dupout=AAA nodupkey;
by var;
run; |
i******n 发帖数: 839 | 9 proc freq;
table var1/out=out1;
data out1;
set out1 (where= count=1);
run; |