Date:         Mon, 9 Oct 2000 09:11:02 +0200
Reply-To:     Krzysztof Pruszczak <krzysiekp@SAWAN.COM.PL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Krzysztof Pruszczak <krzysiekp@SAWAN.COM.PL>
Subject:      Re: Duplicate Observations!
Content-Type: text/plain; charset=iso-8859-2

Hi!

Example in 4gl:

proc sort data=example;
by var1-var7;
run;

data out;
set example;
   by var1-var7;
   if not (first.var7 and last.var7) then output;
run;


ylau1@irix2.gl.umbc.edu wrote:
>
> Hi. Does anyone know how to obtain recrods that have duplicates? For example,
>
> Obs     Var1    Var2    Var3    Var4    Var5    Var6    Var7
> 1       2869    D368    4103    1988    1988    1999    2063
> 2       2869    D368    4103    1988    1988    1999    2063
> 3       5292    D369    0010    1988    1988    1992    2063
> 4       5292    D369    0003    1988    1988    1992    2063
> 5       9232    6944    1892    1988    1988    1991    2063
> 6       9232    6944    1892    1988    1988    1991    2063
> 7       4304    D008    3005    1991    1991    1999    2063
> 8       4304    D008    3005    1991    1991    1999    2063
> 9       4304    D008    7009    1991    1991    1999    2063
> 10      2096    4108    2800    1988    1992    1998    9063
> 11      4096    7016    2800    1988    1992    1998    2063
>
> I would like to keep observations 1,2,5,6,7, and 8.
>
> Thanks for any help.
>
> Anna

--
       *
 . . n***n
 .*  ('o')
   \  )¢(
    (}  .{)         Krzysztof Pruszczak
  ___(")_(")_  mailto:krzysiekp@sawan.com.pl ____