topic Re: How to delete rows? in SAS Programming

How to delete rows?

Anon123 — Sun, 24 Jul 2016 18:18:46 GMT

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

Re: How to delete rows?

Reeza — Sun, 24 Jul 2016 18:26:05 GMT

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;

Re: How to delete rows?

Anon123 — Sun, 24 Jul 2016 18:36:52 GMT

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.

Re: How to delete rows?

Reeza — Sun, 24 Jul 2016 18:37:47 GMT

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

if count - _n_ <6;