delete row if it's identical to previous one ( if the current row is the same as previous)

SIgnificatif — Tue, 30 Jul 2019 09:43:53 GMT

I would like to ask you how to delete a row if the values of the prvious row are the same (only if all variables are the same)

thank you for your response.

Sincerely.

Re: delete row if it's identical to previous one ( if the current row is the same as previous)

Kurt_Bremser — Tue, 30 Jul 2019 11:07:21 GMT

Two ways:

proc sort data=have out=want nodupkey;
by _all_;
run;

proc sql;
create table want as select distinct * from have;
quit;

If you have to keep the original order (and the duplicates always appear in direct succession), expand the first method:

data int;
set have;
__count = _n_;
run;

proc sort
  data=int
  out=want (drop=__count)
  noduprec
;
by __count;
run;