Solved
Contributor
Posts: 29

# How to calculate the week of the year!

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'.

Thanks

Accepted Solutions
Solution
‎09-10-2012 06:48 PM
PROC Star
Posts: 8,169

## Re: How to calculate the week of the year!

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;

All Replies
PROC Star
Posts: 8,169

## Re: How to calculate the week of the year!

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.

Contributor
Posts: 29

## Re: How to calculate the week of the year!

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

PROC Star
Posts: 8,169

## Re: How to calculate the week of the year!

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

Contributor
Posts: 29

## Re: How to calculate the week of the year!

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

Solution
‎09-10-2012 06:48 PM
PROC Star
Posts: 8,169

## Re: How to calculate the week of the year!

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;

🔒 This topic is solved and locked.