How to calculate the week of the year!

[Rish]

Hello Guru's;

I have a SAS date and want to convert it to week day of the year (for mulitple years).

For example 08JAN2009 show as '2 week of 2009'.

Can anybody please advise?

Thanks

[art297]

You could use the week function.  i.e.:

WEEK( date <, 'descriptor'> )

returns the week of year from a SAS date value. The algorithm used to calculate the week depends on the descriptor.

If the descriptor is 'U,' weeks start on Sunday and the range is to . If weeks and exist, they are only partial weeks. Week 52 can be a partial week.

If the descriptor is 'V', the result is equivalent to the ISO 8601 week of year definition. The range is to . Week is a leap week. The first week of the year, Week , and the last week of the year, Week or , can include days in another Gregorian calendar year.

If the descriptor is 'W', weeks start on Monday and the range is to . If weeks and exist, they are only partial weeks. Week 52 can be a partial week.

[Rish]

Arthur -

Tried to run the below code - giving error. Any advise please.

data xyz;

     set web.pmrate (keep= customer datefield);

     week(datefield, 'v');

run;

Thanks

[art297]

what version of SAS are you using and what was the error?

[Rish]

Hi Arthur,

Following is the information:

SAS 9.2 version 4.3

error: undeclared array referenced; week.

error 22-322: syntax error, expecting one of the following: +, =.

error 76-322: syntax error, statement will be ignored.

Thanks       

[art297 · Accepted solution]

Sorry, I just noticed your code.  You never stipulated a variable for SAS to create.  Try something like:

data xyz;

     set web.pmrate (keep= customer datefield);

     week=week(datefield, 'v');

run;