How to delete rows?

[Anon123]

How do I delete the last six rows of a dataset?

[Reeza]

Use NOBS and delete. I'm not sure if it should be less than or less than and equal to in the comparison so both are there. 

One will work for you. 

data want;
set sashelp.class NOBS=COUNT;

if NOBS - _n_ < 6 then delete;
*if NOBS - _n_ <= 6 then delete;
run;

[Anon123]

Thanks however it is not working for me. I get this log:


643
644 data thesis.rank_ndC;
645 set thesis.rank_ndd NOBS=COUNT;
646
647 if NOBS - _n_ < 6 then delete;
648 run;

NOTE: Variable NOBS is uninitialized.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
25 at 647:9
NOTE: There were 25 observations read from the data set THESIS.RANK_NDD.
NOTE: The data set THESIS.RANK_NDC has 0 observations and 11 variables.

[Reeza · Accepted solution]

Sorry, it should be COUNT in the IF statement, not NOBS.

if count - _n_ <6;