topic Re: how to start the calculation on a column having datetime to identify weekdays first post which the calculation should start in SAS Enterprise Guide

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

sharath_rk — Wed, 05 Feb 2014 09:24:07 GMT

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.

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

LinusH — Wed, 05 Feb 2014 10:25:34 GMT

Sorry, I don't understand your issue.

Please post some sample input and desired output data.

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

sharath_rk — Wed, 05 Feb 2014 10:36:07 GMT

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

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

LinusH — Wed, 05 Feb 2014 11:27:53 GMT

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.

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

sharath_rk — Wed, 05 Feb 2014 11:31:24 GMT

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

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

LinusH — Wed, 05 Feb 2014 11:34:02 GMT

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

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

Amir — Wed, 05 Feb 2014 13:33:33 GMT

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.

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

ChrisHemedinger — Wed, 05 Feb 2014 13:38:45 GMT

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

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

sharath_rk — Wed, 05 Feb 2014 13:58:08 GMT

That worked. Thank you Amir.

Chris,

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

Regards

Sharath

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

rcwright — Thu, 11 Dec 2014 16:10:46 GMT

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