topic Re: How to find the last day of the month in SAS Programming

How to find the last day of the month

SASuserlot — Wed, 14 Apr 2021 15:01:00 GMT

I have the dates like 2018-01, 2014-02, 1996-08, 2012-06, I would like to find the last day of that month (like is 31, 30 , or 28). I believe it also need to include if any leap years are there. Thanks in advance

Re: How to find the last day of the month

Reeza — Wed, 14 Apr 2021 15:18:52 GMT

endMonth = intnx('month', dateVariable, 0, 'e');

Use INTNX and the alignment parameter, E, which will align a date to the end of the month.

@SASuserlot wrote:

I have the dates like 2018-01, 2014-02, 1996-08, 2012-06, I would like to find the last day of that month (like is 31, 30 , or 28). I believe it also need to include if any leap years are there. Thanks in advance

Re: How to find the last day of the month

PaigeMiller — Wed, 14 Apr 2021 15:20:29 GMT

Are these character strings, or numeric dates formatted to appear as 2018-01?

The INTNX function makes it easy to determine the last day of the month, if you have numeric dates in a variable which I have creatively named VARIABLENAME. The 'e' tells INTNX to find the last day of the month contained in VARIABLENAME.

last_day_of_month=intnx('month',variablename,0,'e');

Re: How to find the last day of the month

SASuserlot — Wed, 14 Apr 2021 15:24:59 GMT

thanks it worked

Re: How to find the last day of the month

SASuserlot — Wed, 14 Apr 2021 15:25:14 GMT

thanks it worked