topic Re: How to calculate last sunday of month in SAS Programming

How to calculate last sunday of month

Brad39 — Sun, 16 Feb 2020 07:13:34 GMT

Hi,

I want to locate the last sunday of month but I am confused whether the following syntax is correct or not.

or there is any other way to locate it?

last sunday=INTNX ('WEEK', INTNX('MONTH', TODAY() , 0, 'E') , 0 , 'B')

Please if you could help here.

Thanks!

Re: How to calculate last sunday of month

Patrick — Sun, 16 Feb 2020 08:31:44 GMT

Looks good to me.

You take a date and shift it forward to the last day of the month. Then you shift that last day of the month back to the first day of the week the last day of the month is in. With SAS the first day of the week is Sunday.

Re: How to calculate last sunday of month

Brad39 — Sun, 16 Feb 2020 08:17:14 GMT

Thank alot

Re: How to calculate last sunday of month

Ksharp — Sun, 16 Feb 2020 08:17:48 GMT

Or try another function : NWKDOM(n, weekday, month, year)

last_sunday=nwkdom( 5 , 1, 2 , 2020) ;

-- 5 is for the last week within a month

-- 1 is for sunday

Re: How to calculate last sunday of month

Patrick — Sun, 16 Feb 2020 08:21:23 GMT

@Ksharp

Learned something new 🙂

Looks like there is a SAS function for almost everything. ....hopefully we will also get "call zero()/call value()" one day.

Re: How to calculate last sunday of month

Ksharp — Sun, 16 Feb 2020 08:28:47 GMT

Patrick,

OP's statement is also brilliant , which remind me to learn this idea from yours .