Create a formula to remove weekends dates

[DandarahZ]

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

[Jagadishkatam]

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;

[FredrikE]

Hi!

You can add a filter with the following expression:

DayOfWeek('Date'n) < 6

//Fredrik

[DandarahZ]

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

[FredrikE · Accepted solution]

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