retrieve one row before end

[Ronein]

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;

[Ronein · Accepted solution]

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;

[PGStats]

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;