topic Re: Week function in SAS Programming

Week function

SASdevAnneMarie — Thu, 25 Jan 2024 18:31:13 GMT

Hello Experts,

I would like to get the real number of the week. Do I need to use week(Date,'v') ?

Thank you !

Re: Week function

PaigeMiller — Thu, 25 Jan 2024 18:51:17 GMT

You could use week(Date,'v') or week(Date,'w') or week(Date,'u'), whichever works for you.

Re: Week function

SASKiwi — Thu, 25 Jan 2024 19:24:35 GMT

What do you mean by "real number of the week"? There are different recognised definitions for week number and you need to decide which one to use. The SAS doc explains the definitions.

Here is a link to the ISO definition of week number (week date): https://en.wikipedia.org/wiki/ISO_week_date

The SAS 'V' method gives the ISO definition.

Re: Week function

mkeintz — Thu, 25 Jan 2024 19:02:43 GMT

One of the best skills a SAS user can develop is flexible use of the internet.

A search (using duckduckgo) for

sas week function 9.4

(I include "9.4' in the search because without it, usually versi0n 9.3 documentation shows up first).

This yields a number of promising links, one of which is a pdf file:

SAS® 9.4 Functions and CALL Routines: Reference, Fifth Edition

See page 1610 of the above.

Re: Week function

SASdevAnneMarie — Fri, 26 Jan 2024 13:43:13 GMT

Thank you for your answear, I would like to have the first week with number 1, not 0.

Re: Week function

PaigeMiller — Fri, 26 Jan 2024 13:47:00 GMT

@SASdevAnneMarie wrote:
Thank you for your answear, I would like to have the first week with number 1, not 0.

Not sure what this means, first week of what year? How do you define first week?

Why don't you just add 1 to the week zero answer you are getting?

Anyway, if I were you, I would try the three different options of the WEEK function and see if one of them does what you want.

Re: Week function

ballardw — Fri, 26 Jan 2024 15:25:58 GMT

@SASdevAnneMarie wrote:
Thank you for your answear, I would like to have the first week with number 1, not 0.

Rules for "first week". For example first week of what? Calendar year? Fiscal Year? Month? Calendar quarter?

Example data values, I have to assume dates, as a working data step and the expected result. Read the documentation on the week function and the U V and W options. If one of them matches use it. If not, describe what you actually want with values and rules.

Re: Week function

SASKiwi — Fri, 26 Jan 2024 21:14:01 GMT

According to the WEEK function doc the 'V' option counts from 1. The U and W options start from 0. As I already mentioned the V option does the ISO definition.

Re: Week function

Tom — Sat, 27 Jan 2024 15:38:17 GMT

@SASdevAnneMarie wrote:
Thank you for your answear, I would like to have the first week with number 1, not 0.

First week of what interval? A year? A month?

What day of the week does a week start on? Is it Sunday? Or do weeks always start of the day of the week that Jan01 falls on?

What do you do with partial week at the start of a year? Say Jan01 is on a Tuesday? does that mean that week 1 only has 5 days (from Tuesday to Saturday) instead of 7 days? Or does week one has 12 days instead of 7?

What do you do with partial week at the end of the year? Take the year 2012, that started on a Sunday. Does that mean the Dec30 and 31 are part of week 53 for 2012? Or are they part of week 1 for 2013?

Re: Week function

SASdevAnneMarie — Mon, 29 Jan 2024 15:13:14 GMT

Thank you very much !