Remove duplicate

[Prabhat_kumar]

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

[PeterClemmensen]

Show us your code please.

[Prabhat_kumar]

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

rownumber_partitiion.png

[andreas_lds]

And what do you expect as result?

[Prabhat_kumar]

The expected result.expected_result.png

[andreas_lds]

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;

[FloydNevseta]

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;