topic Re: How to find the week number of a month? in SAS Programming

How to find the week number of a month?

AndyTeng — Sat, 25 Aug 2018 14:46:39 GMT

Hi, everyone

If I have a data format "20180825" for the Date column, how do I find the week number of the month for that date (i.e. the fourth week of Aug in 2018)? I need your help for this question ASAP. Thanks a lot.

Re: How to find the week number of a month?

Jagadishkatam — Sat, 25 Aug 2018 14:59:01 GMT

data have;
input date:anydtdte.;
 week=intck('week',intnx('month',date,0),date)+1; 
format date date9.;
cards;
20180825
;

Re: How to find the week number of a month?

Astounding — Sat, 25 Aug 2018 21:17:30 GMT

If you need the answer ASAP, you should provide the rest of the relevant information.

Is your date variable an eight-digit number, or is it an eight-digit character string, or is it already a SAS date?

What is your definition of a week? Are the first seven days of the month all in week 1? Even if the first of the month is Wednesday?

Depending on your answers, here is a formula that might come in handy:

weeknum = ceil(day(datevar) / 7);

Re: How to find the week number of a month?

novinosrin — Sat, 25 Aug 2018 21:34:11 GMT

@Astounding Sir, elegance personified. Very neat!

Re: How to find the week number of a month?

AndyTeng — Sun, 26 Aug 2018 02:52:29 GMT

Hi, Astounding

Thank you for your reply.

Yes, I think it's a eight-digit number. I don't have definite definition for the week number of a month. It would be fine if the program can help to show the sequence of a week within a month. BTW, I got the following message by implementing your suggested code:

NOTE: Invalid argument to function DAY(20021030) at line 1998 column 33.

If you have any suggestion, please let me know. Thank you very much.

Re: How to find the week number of a month?

Jagadishkatam — Sun, 26 Aug 2018 03:07:44 GMT

Hi I tried the below and it worked with no issues

data have;
input date:anydtdte.;
weeknum = ceil(day(date) / 7);
format date date9.;
cards;
20021030
;

Re: How to find the week number of a month?

Astounding — Sun, 26 Aug 2018 11:27:20 GMT

That can be fixed. You need to treat the date as a valid SAS date, not as an eight-digit number. Unfortunately, it gets a little complex, so I'll break it out as two separate statements:

data want;

set have;

true_sasdate = input(put(datevar, z8.), yymmdd8.);

weeknum = ceil( day(true_sasdate) / 7);

run;

Re: How to find the week number of a month?

AndyTeng — Mon, 27 Aug 2018 04:44:40 GMT

Hi, Astounding
It works!
Yes, I have to transform the date to a valid SAS date first.
Thank you very much.