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

[SIgnificatif]

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.

[Kurt_Bremser · Accepted solution]

Two ways:

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

or

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;