topic Re: Date & Week Numbers in SAS VA in SAS Visual Analytics

Date & Week Numbers in SAS VA

sat_lr — Tue, 24 Jun 2014 07:13:04 GMT

Hi,

I have invoice list with dates. As the customer wants to see sales by week, I would like to consume the date in the form of Weeks with numbers. ex: week 1, week 2 week 3 with sales figures.

All I have is dates. I am able to manipulate my dates with all the options available like weekdays, quarter (q1, q2, q3, q4) etc. But I couldn't get weeks with number option.

Pls help with your suggestions. Thanks.

cheers

-satlr

Re: Date & Week Numbers in SAS VA

PeterWijers — Fri, 27 Jun 2014 04:32:01 GMT

Hi Sat_Ir,

If you have a dataset with a date (Invoice date) you can use the week number function (VA 6.3)

Create a new Calculated Item and use the formula week number(Invoice date).

Now you get the week number of the Invoice date. Do not forget to switch the numeric field to a Category before you start using it.

Ones it is a category, you can use it as a label in graphs or tables.

Sure this will work.

Otherwise this is the mathematical function

week_nr= INT(1+int((date+(3-mod(weekday(date)+5,7))-intnx('year',date+(3-mod(weekday(date)+5,7)),0))/7));

Greetings

Re: Date & Week Numbers in SAS VA

sat_lr — Mon, 07 Jul 2014 06:36:52 GMT

brilliant! thanks Wijers. will try to incorporate this expression.

cheers.

satlr

Re: Date & Week Numbers in SAS VA

NikNizan — Thu, 22 Oct 2015 00:20:04 GMT

Hi, my problem is somewhat similar as I would like to use WeekNum as a Date Measure for the Geo Bubble Map looping animation slider. WeekNum once converted to Category doesn't allow it to be used as an Animation variable. Any workaround?

Re: Date & Week Numbers in SAS VA

Sam_SAS — Thu, 22 Oct 2015 13:11:04 GMT

Hello,

Animation requires a date, time, or datetime variable.

Unfortunately, I don't think there is any way to create a date from week number in VA.

In theory such a thing could be possible if you provide the year and the week number, but VA does not offer a function to do this calculation.

Thanks,
Sam