topic Count months from date to the end of the year in SAS Data Management

Count months from date to the end of the year

PatrykSAS — Fri, 13 Mar 2020 15:52:22 GMT

Hi, I'd like to see a number of months left from the date to the end of the year.

I know to count month I can use intck('month', 'start', 'end', 'D') but how to get the "end" date when it's not given. I dont know how to pass the 'end' argument. Only what I got is the start date.

I would like to see:

date months

01JUN2019 7

01APR2020 9

Have a good day 🙂

Re: Count months from date to the end of the year

novinosrin — Fri, 13 Mar 2020 15:58:46 GMT


data have;
input date :date9. ;* months;
format date date9.;
cards;
01JUN2019                7
01APR2020                9
;

data want;
 set have;
 Months=intck('mon',date,intnx('year',date,0,'e'))+1;
run;

Re: Count months from date to the end of the year

Reeza — Fri, 13 Mar 2020 16:02:12 GMT

You can find the end of the year with the following code:

year_end = intnx('year', today(), 0, 'e');

months = intck('month', date, year_end, 'D');

You can nest those if needed.

@PatrykSAS wrote:

Hi, I'd like to see a number of months left from the date to the end of the year.

I know to count month I can use intck('month', 'start', 'end', 'D') but how to get the "end" date when it's not given. I dont know how to pass the 'end' argument. Only what I got is the start date.

I would like to see:

date months

01JUN2019 7

01APR2020 9

Have a good day 🙂

Re: Count months from date to the end of the year

Kurt_Bremser — Fri, 13 Mar 2020 16:02:32 GMT

Use intnx() to get year's end (actually the start of next year since you want the current month to be counted also):

data want;
input date :date9.;
months_left = intck('month',date,intnx('year',date,0,'e') + 1);
format date yymmddd10.;
datalines;
01JUN2019
01APR2020
;