DATA Step, Macro, Functions and more

How to delete rows?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

How to delete rows?

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


Accepted Solutions
Solution
‎07-24-2016 02:38 PM
Super User
Posts: 17,960

Re: How to delete rows?

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

 

if count - _n_ <6;

View solution in original post


All Replies
Super User
Posts: 17,960

Re: How to delete rows?

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;
Occasional Contributor
Posts: 6

Re: How to delete rows?

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)Smiley SadColumn).
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.
Solution
‎07-24-2016 02:38 PM
Super User
Posts: 17,960

Re: How to delete rows?

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

 

if count - _n_ <6;

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 274 views
  • 0 likes
  • 2 in conversation