如何删除重复观测？

shiyiming

发现数据集中有重复记录，该如何删除重复的呢？

shiyiming

[code:qr5rtjp1]data a;
        x=1;y=1;output;
        x=1;y=1;output;
run;
/*方法一:*/
proc sql noprint;
        create table result as
                select distinct * from a;
quit;
/*方法二：*/
proc sort data=a out=result noduprecs;
        by _all_;
run;
[/code:qr5rtjp1]

shiyiming

<!-- m --><a class="postlink" href="http://sxlion.spaces.live.com/blog/cns!C7ABA890CA87EC80!127.entry">http://sxlion.spaces.live.com/blog/cns! ... !127.entry</a><!-- m -->

上面提供了几种方法供参考。

shiyiming

data a1.y1;
set a1.y1;
by x1 x2;
if last.x2 then output;
run;

shiyiming

distinct