how to start the calculation on a column having datetime to identify weekdays first post which the calculation should start

[sharath_rk]

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. 

[LinusH]

Sorry, I don't understand your issue.

Please post some sample input and desired output data.

[sharath_rk]

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

[LinusH]

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.

[sharath_rk]

Thanks. How can i exclude weekends from the colum 1 having date & time?

[LinusH]

Depending on your final technique, but usually involving the datepart() function can be of help.

[Amir]

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.

[ChrisHemedinger]

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

[sharath_rk]

That worked. Thank you Amir.

Chris,

That would be my next step. Will check the custom networkdays function. Thank you.

Regards

Sharath

[rcwright]

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).