Please assist.I could not use INTCK function as there's only one column from which i need the calculation to start if the day is weekday.
Sorry, I don't understand your issue.
Please post some sample input and desired output data.
Hi,
Please see the two columns below. Column 2 is a calculated field which should show as Y for weekday and N for weekend/holiday. However it is showing as Y for 25th & 26th Jan which are weekends. How do i exclude weekends before i start the calculation.
Column 1 | Column 2 |
25JAN2014:00:06:13.000000 | Y |
25JAN2014:00:08:32.000000 | Y |
25JAN2014:00:14:15.000000 | Y |
25JAN2014:00:18:39.000000 | Y |
25JAN2014:00:18:40.000000 | Y |
26JAN2014:14:58:33.000000 | Y |
26JAN2014:14:58:47.000000 | Y |
26JAN2014:14:59:18.000000 | Y |
26JAN2014:15:01:15.000000 | Y |
27JAN2014:00:01:10.000000 | Y |
27JAN2014:00:03:46.000000 | Y |
27JAN2014:00:00:00.000000 | Y |
27JAN2014:00:00:00.000000 | Y |
28JAN2014:00:00:00.000000 | Y |
28JAN2014:00:00:00.000000 | Y |
28JAN2014:00:00:00.000000 | Y |
28JAN2014:00:00:00.000000 | Y |
29JAN2014:00:00:00.000000 | Y |
29JAN2014:00:00:00.000000 | Y |
29JAN2014:00:00:00.000000 | Y |
30JAN2014:00:00:00.000000 | Y |
30JAN2014:00:00:00.000000 | Y |
30JAN2014:00:00:00.000000 | Y |
Ok, if you are relying on US holidays, use the holiday() function.
If not, you need some kind of calendar data set/user defined format to handle holidays outside the US.
Thanks. How can i exclude weekends from the colum 1 having date & time?
Depending on your final technique, but usually involving the datepart() function can be of help.
Hi,
Further, the weekday() function returns a day number (1-7) which you can test to exclude weekends.
SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition
Regards,
Amir.
If you're looking for a way to calculate "working days" (calendar days minus weekends and holidays), perhaps you can use this custom networkdays function:
Calculating the number of working days between two dates - The SAS Dummy
Chris
That worked. Thank you Amir.
Chris,
That would be my next step. Will check the custom networkdays function. Thank you.
Regards
Sharath
Take a look at the WeekDay() function. Give a date value, it returns 1-7, where 1=Sunday, 7=Saturday indicating the day of the week
To convert from Date-Time, use the DatePart() function,
So,
isweekday = (WeekDay(DatePart(dtvalue)) IN (2..6)); * think I got the parens right ;
returns, 0 (false), or 1(true).
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.