Match with the last day of month

[SASdevAnneMarie]

Hello Experts,

I have a dates in my data, I would like to chose the row where the date (format ddmmyy10.) are equal to the last day of month. Do you know please if sas has some function for this ?

Thank you very much !

[PaigeMiller · Accepted solution]

The INTNX function will compute the last day of any month. To find the last day of the current month, in a DATA step use:

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

If you want the last day of some other month, use a variable that has a valid SAS date value in place of today()

[SASdevAnneMarie]

Thank you Paige Miller !