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; |
