SAS Week

What is it?

• The Week function returns and integer value 0 and 52 and or 1 and 53 depending on additional parameters.
• Arguably, the Week function could also be called the Week of year Function
• Sunday represents the first day of any given week

Syntax:

• Week(date'YYYY-MM-DD');
• Week(date'YYYY-MM-DD','U');
• Week(date'YYYY-MM-DD','V');
• Week(date'YYYY-MM-DD','W');

SAS Week Statement:

 SAS Week Example:

Data work.my_data_file;     Result_1 = Week(today());     Result_2 = Week(today(),'u');     Result_3 = Week(today(),'v');     Result_4 = Week(today(),'w'); Run;

What's happening in the script above?

• The Week(); Function is calculating the week count based on today (April 8th 2021)
• The [U], [V], [W] are additional parameters that are related to the gregarian calculator

Week Example:

Variable	Input	Output	Description
Result_1	Week(22378)	14	The number of weeks into a year.
Result_2	Week(22378, 'u')	14	See Above
Result_3	Week(22378, 'v');	14	See Above
Result_4	Week(22378, 'w');	14	See Above

See also; DAY Function