topic Re: How to pick a one before last date in SAS Enterprise Guide

How to pick a one before last date

PatrykSAS — Tue, 03 Nov 2020 16:25:34 GMT

Hi, how can I exclude a date that is one before last from the table

Table

2020-01-15

2020-04-23

2020-05-13

2020-06-26

Result

2020-05-13

can I do this in an easy and fast way?

Re: How to pick a one before last date

novinosrin — Tue, 03 Nov 2020 16:36:54 GMT

data have;
input date yymmdd10.;
format date yymmdd10.;
cards;
2020-01-15
2020-04-23
2020-05-13
2020-06-26
;

data want;
 _n_=nobs-1;
 set have nobs=nobs point=_n_;
 output;
 stop;
run;