topic Re: Delete last row datastep in SAS Programming

Delete last row datastep

Q1983 — Wed, 26 Sep 2018 01:17:18 GMT

data have;

input ln_no $ state $ loans amt;

datalines;

1123 AL 1 100

1123 AL 2 150

1233 AL 2 150

CA 3 50

;

run;

data want;

/*if last. then delete;run;*/

end = last;

if not last then output;

run;

I have tried several methods to delete the last row of the datastep. How would I delete the last observation

Re: Delete last row datastep

novinosrin — Wed, 26 Sep 2018 01:53:01 GMT

did you miss the set statement?

data want;

set have end = last;

if not last then output;

run;

Re: Delete last row datastep

VDD — Wed, 26 Sep 2018 01:56:14 GMT

data have;
input ln_no : $ state : $ loans amt;
datalines;
1123 AL 1 100
1123 AL 1 100
1123 AL 2 150
1233 AL 2 150
1234 CA 3 50
;
run;
data want;
	set have end=last;
	if not last then output;

run;

Re: Delete last row datastep

art297 — Wed, 26 Sep 2018 15:39:21 GMT

This question was cross posted on the SAS-L bulletin board. There, @data_null__ showed a method that is way more efficient, namely one that doesn't require reading and re-writing all of the records you want to keep:

data have;
  point=nobs;
  modify have nobs=nobs point=point;
  remove;
  stop;
run;

Art, CEO, AnalystFinder.com

Re: Delete last row datastep

novinosrin — Wed, 26 Sep 2018 15:40:58 GMT

Thank you @art297 . Just out of curiosity, do you still see much traffic on SAS-L?

Re: Delete last row datastep

art297 — Wed, 26 Sep 2018 15:50:59 GMT

@novinosrin: No, the traffic there has been diminishing for a number of years now. However, I still look there every day as it doesn't require a lot of time and I still learn things that I otherwise would have missed.

Art, CEO, AnalystFinder.com