last date

[BrahmanandaRao]

Hi guys Goodmorning,

in this data set i want including last date like below 

2016-02-29

2017-05-31

2018-06-30

2019-02-28

data dsn;
input date yymmdd10.;
format date yymmdd10.;
datalines;
201602
201705
201806
201902
;
run;

[PeterClemmensen]

Assuming your data is sorted.. Also, I corrected your test data

data dsn;
input date :yymmdd10.;
format date yymmdd10.;
datalines;
2016-02-29
2017-05-31
2018-06-30
2019-02-28
;
run;

data want;
   set dsn end=lr;
   if lr;
run;

[BrahmanandaRao]

Hi Draycut

keep it datalines as it is 

201602
201705
201806
201902

but i want output like below

2016-02-29

2017-05-31

2018-06-30

2019-02-28

[andreas_lds]

Sorry, but

data dsn;
input date yymmdd10.;
format date yymmdd10.;
datalines;
201602
201705
201806
201902
;
run;

is not working at all, please fix it. As soon as you have a sas-date, you can use intnx to move it to end of the month by using

date = intnx('month', date, 0, 'E');

[PeterClemmensen · Accepted solution]

Ok. Do like this then

data dsn;
input date;
format date;
datalines;
201602
201705
201806
201902
;
run;

data want;
   set dsn;
   date=intnx('month', input(put(date, 6.), yymmn6.), 0, 'e');
   format date yymmdd10.;
run;

[BrahmanandaRao]

Thank you very much