How to find the last day of the month

[SASuserlot]

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

[Reeza · Accepted solution]

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

---

[SASuserlot]

thanks it worked

[PaigeMiller]

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

[SASuserlot]

thanks it worked