topic Match with the last day of month in SAS Programming

Match with the last day of month

SASdevAnneMarie — Tue, 28 Mar 2023 13:00:54 GMT

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 !

Re: Match with the last day of month

PaigeMiller — Tue, 28 Mar 2023 13:05:07 GMT

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()

Re: Match with the last day of month

SASdevAnneMarie — Tue, 28 Mar 2023 13:06:30 GMT

Thank you Paige Miller !