topic Re: Getting SAS to recognize weeks in SAS Procedures

Getting SAS to recognize weeks

TMorville — Thu, 04 Nov 2010 10:06:31 GMT

Hello everyone.

I have a dataset with approx 15000 observations, that all have a date marking like "13MAY2010" but distributed over several months.

What i would like SAS to do, is to recognize each date, and then give a new variable called "week" the weeknumber. An example could be, that 13MAY2010 would be marked with "23" because its the 23 week of 2010.

I've googled all morning and searched though the forum with no luck.

Thanks a bunch!

Re: Getting SAS to recognize weeks

deleted_user — Thu, 04 Nov 2010 10:48:58 GMT

Hm, I might be missing something but I think this is fairly simple, ie. I would create a new variable in a data step:

data new; set old;
wn=week(mydate);

Now, to me 13MAY2010 would indicate week # 19, but I guess it depends on if the week starts on a Sunday or a Monday...

Cheers!

Re: Getting SAS to recognize weeks

TMorville — Thu, 04 Nov 2010 10:54:47 GMT

Ha!

That did work. Simple enough. Thanks!

Re: Getting SAS to recognize weeks

deleted_user — Thu, 04 Nov 2010 10:55:47 GMT

Yess! You made my day - I was able to help someone 😉

Re: Getting SAS to recognize weeks

TMorville — Mon, 08 Nov 2010 13:10:43 GMT

So. Now im at a new standstill..

Is there anyway to redefine the week() function, so that the week starts every monday?

Re: Getting SAS to recognize weeks

SPR — Mon, 08 Nov 2010 15:48:37 GMT

Hello TMorville,

SAS help says that it is necessary to use "V" or "W" descriptor to switch to Monday, say:

Week("01Feb2010"d,"W");

Sincerely,
SPR