topic Re: Delete the last observation in a data Step in SAS Programming

Delete the last observation in a data Step

Chaseg22 — Mon, 30 May 2016 16:10:49 GMT

Hi All,

I am using the infile statement to import text files and I am trying to import everything EXCEPT the last row (as it is the Grand Totals). The last row is dynamic, it could be row 14 or row 20. Is there a way to import N-1 rows?

Thank you

data Work.Test ;
infile &DataFile dlm=',' firstobs=3 dsd;
length Time_Period $30;
input
Time_Period
ID
Customers

;

run;

Re: Delete the last observation in a data Step

PGStats — Mon, 30 May 2016 18:42:46 GMT

I would try:

infile &DataFile dlm=',' firstobs=3 dsd obs=nobs;

if _n_ = nobs then stop;

Re: Delete the last observation in a data Step

Ksharp — Tue, 31 May 2016 01:26:09 GMT

data x;
 infile '/folders/myfolders/want.txt' end=last length=len;
 input x $varying200. len;
 if not last then output;
run;