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).
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.