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!
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.
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.
Thank alot
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
Learned something new 🙂
Looks like there is a SAS function for almost everything. ....hopefully we will also get "call zero()/call value()" one day.
Patrick,
OP's statement is also brilliant , which remind me to learn this idea from yours .
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: