求删除sas数据集中重复值的方法

proc sort data=dsn out=dsn_sorted;
  by var;
run;
data dsn_sorted_result;
  set dsn_sorted;
  by var;
  if first.var=1 and last.var=1;
run;

chai_prime 发表于 2011-12-28 22:31
这样应该可以把重复的部分“全部删除”

proc sql;
create table temp1 as
  select * from temp  group by key
having n(key)=1;
quit;

我也同意楼上。

顶楼主，我也需要

proc sql;
create table tmp1 as
select *
from tmp group by key
having n(key)=1;
quit;

chai_prime 发表于 2011-12-28 22:31
这样应该可以把重复的部分“全部删除”

第二个data步没必要把，可以在sql里面加个 having

data 步也可以的啦

first.x

data test;
input x y;
cards;
1 2
1 3
1 4
2 5
2 7
;
run
proc sort data=test;
run
data test_last;
set test;
by x;
if first.x;
run;

proc sql;
create table tmp1 as
select *
from tmp group by key
having n(key)=1;
quit;