topic Re: Remove duplicate in SAS Programming

Remove duplicate

Prabhat_kumar — Thu, 03 Sep 2020 06:59:17 GMT

Hi All,

I am trying to delete the last 3 row where last row "label=B_Contingencies" (highlighted in image).

I tried rownum and partition but seems like sas doesn't support it.need to remove last 3 row

Re: Remove duplicate

PeterClemmensen — Thu, 03 Sep 2020 07:03:09 GMT

Show us your code please.

Re: Remove duplicate

Prabhat_kumar — Thu, 03 Sep 2020 07:17:50 GMT

This was throwing error as "Syntax expecting one of the following: !,!!, &, *, **, +,-,/,* <,>,<>,="

Re: Remove duplicate

andreas_lds — Thu, 03 Sep 2020 07:30:23 GMT

And what do you expect as result?

Re: Remove duplicate

Prabhat_kumar — Thu, 03 Sep 2020 07:39:25 GMT

The expected result.

Re: Remove duplicate

andreas_lds — Thu, 03 Sep 2020 08:43:09 GMT

Something like this should work. Code is untested:

data want;
   _p = 0;
   
   do _n_ = 1 by 1 until(done);
      set work.have end=done;
      if label = 'INSERT_TEXT' then _p = _n_;
   end;

   do _n_ = 1 by 1 until(_p - 1 = _n_);
      set work.have;
      output;
   end;
   
   drop _p;
run;

Re: Remove duplicate

FloydNevseta — Thu, 03 Sep 2020 14:53:23 GMT

Assuming that 'end' provides some meaningful order, then you can try this.

* sort by label and end to group by label;
proc sort data=iqfmt;
by label end;
run;

* then sort by label removing duplicate labels;
proc sort data=iqfmt nodupkey;
by label;
run;