Finding prior week number of the month

West26 — Sat, 03 Oct 2020 16:17:22 GMT

By using the below code, I'm able to identify the current week number of the month. Thanks for the previous post by user: ballardw ( Posted 05-18-2017 07:23 PM )

data _null_;

week = week(today()) - week((intnx('month',today(),0,'B'))) +1;

call symputx('week',week);

run;

But I am facing difficulty, while running a report, which has to list the last week number......which means, if I am running a report now, it has to give me last week number, which is week4 (Here, I need to run a report that lists the data from last Monday to Saturday, i.e. 21st September to 27th September).

Any kind of help is greatly appreciated. Thanks

Re: Finding prior week number of the month

Kurt_Bremser — Sat, 03 Oct 2020 16:40:51 GMT

Subtract 7 from your two TODAY() calls.

Re: Finding prior week number of the month

West26 — Sat, 03 Oct 2020 16:47:14 GMT

Thank you Sir. Appreciated.

topic Re: Finding prior week number of the month in SAS Programming

Finding prior week number of the month

Re: Finding prior week number of the month

Re: Finding prior week number of the month