topic Re: retrieve one row before end in SAS Programming

retrieve one row before end

Ronein — Sun, 07 Apr 2019 04:00:12 GMT

Hello friends

I want to ask please what is the best way to retrieve one row before end.

For example:

I want to retrieve the row with mon=1901 (because it is one row before the end)

Data tbl1;
informat start date9. end date9.;
format start date9. end date9.;
input mon start end;
cards;
1812 '21DEC2018'd '21Jan2019'd
1901 '22Jan2019'd '21Feb2019'd
1902 '22Feb2019'd '21Mar2019'd
;
run;

Re: retrieve one row before end

Ronein — Sun, 07 Apr 2019 04:18:27 GMT

I found the solution

Data tbl1;
informat start date9. end date9.;
format start date9. end date9.;
input mon start end;
cards;
1812 '21DEC2018'd '21Jan2019'd
1901 '22Jan2019'd '21Feb2019'd
1902 '22Feb2019'd '21Mar2019'd
;
run;



data tbl2;
set tbl1 nobs=nobs;
if _n_ =nobs-1 then keep=1;
if keep ne 1 then delete;
run;

Re: retrieve one row before end

PGStats — Sun, 07 Apr 2019 04:23:14 GMT

Like this, you read only one record of the set:

data junk;
point = max(1, nobs - 1);
set sashelp.class point=point nobs=nobs;
output; stop;
run;