topic Re: Create a formula to remove weekends dates in SAS Visual Analytics

Create a formula to remove weekends dates

DandarahZ — Wed, 30 Oct 2019 03:42:39 GMT

Hello,

I have a data set with a "Time" column. In this column, the data is saved in the DATETIME format (dd/mm/yyyy hh: mm). In VA, I managed to segregate the values into 2 new variables. The first being Date, the second being Time.

I, however, would like to now modify the DATE variable to exclude dates that are on the weekends. Can i get some help on this matter

Regards

Dan

Re: Create a formula to remove weekends dates

Jagadishkatam — Wed, 30 Oct 2019 05:02:07 GMT

Please try, here the x represents 6=saturday and 7=sunday which we are excluding

data want;
set have;
x=weekday('16mar97'd);
if x not in (6,7);
run;

Re: Create a formula to remove weekends dates

FredrikE — Wed, 30 Oct 2019 07:29:28 GMT

Hi!

You can add a filter with the following expression:

DayOfWeek('Date'n) < 6

//Fredrik

Re: Create a formula to remove weekends dates

DandarahZ — Thu, 31 Oct 2019 02:15:09 GMT

Hello Mr Fredrick,

I thank you for your reply. However, when trying to input the formula, an error gets thrown stating that it is unable to carry out the process due to a type error.

Regards,

Dan

Re: Create a formula to remove weekends dates

FredrikE — Thu, 31 Oct 2019 10:59:42 GMT

Hi!

I mest you should add a FILTER, not to create a calculated item 🙂

But if you want that, just remove the ”<6” from your expression.

//Fredrik