topic last date in New SAS User

last date

BrahmanandaRao — Tue, 02 Jul 2019 05:43:41 GMT

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;

Re: last date

PeterClemmensen — Tue, 02 Jul 2019 05:47:09 GMT

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;

Re: last date

BrahmanandaRao — Tue, 02 Jul 2019 05:53:48 GMT

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

Re: last date

andreas_lds — Tue, 02 Jul 2019 06:11:07 GMT

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');

Re: last date

PeterClemmensen — Tue, 02 Jul 2019 06:11:38 GMT

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;

Re: last date

BrahmanandaRao — Tue, 02 Jul 2019 06:21:42 GMT

Thank you very much