topic Re: calculate a delay between to date without the weekend in SAS Visual Analytics

calculate a delay between to date without the weekend

YannRC — Tue, 09 Apr 2024 07:28:39 GMT

Hello, I know that i can use INTCK on studio but i want to know if i can find a formula in visual Analytics to measure the delay between 2 dates and exclude the week end or blank days.

Re: calculate a delay between to date without the weekend

ballardw — Tue, 09 Apr 2024 13:41:52 GMT

What would a "blank day" be? Never heard that term before.

The INTCK and INTNX functions will use the WEEKDAY as an interval.

Example:

data example;
   day1='05APR2024'd;
   day2='09APR2024'd;
   weekdaysbetween = intck('weekday',day1,day2);
run;

Day1 is a Friday, Day2 is Tuesday. Weekdaysbetween is 2.

Re: calculate a delay between to date without the weekend

YannRC — Tue, 09 Apr 2024 13:46:21 GMT

thanks 🙂

It's a french word. It's a a day where our company don't work like esater or christmas. I already use intck in sas studio but i want tu find a solution on visual analytics with the existing formula

Re: calculate a delay between to date without the weekend

YannRC — Wed, 15 May 2024 18:37:12 GMT

Excuse me for the delay and thank you for your answer.

I know that a can use INTCK on a program or on a flow. But my data table is already here. I want to calculate a delay in days between two date without the saturday ou sunday for example. Only working days.

But i need or want to know if we can do it by using only Calculated items (and formula) in visual analytics.

Re: calculate a delay between to date without the weekend

Patrick — Thu, 16 May 2024 01:57:56 GMT

Does the solution in from discussion SAS-Visual-Analytics-Edit-Calculated-Data-with-Condition answer your question?

Using intck() for an interval Monday-Friday won't be hard but if you also want to exclude holidays then you need a Custom Time Interval. Not sure if and how this works with in-memory tables and VA.

Re: calculate a delay between to date without the weekend

YannRC — Thu, 16 May 2024 11:47:09 GMT

Not Clearly. My target is to do the same thing as INTCK but by using Existing formula.

Re: calculate a delay between to date without the weekend

YannRC — Fri, 17 May 2024 10:30:26 GMT

A parralel Question. INTCK is perfect with weekday but it take the saturday and sunday.

When i put the table on WORK, I can use INTCK("WEEKDAY1W",(DATEPART(Date1)),(DATEPART(date2))) and it works and it only remove the sunday. But when i change and i work on CAS. It's KO.

Is it normal?