Desktop productivity for business analysts and programmers

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

Reply
Contributor
Posts: 51

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

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. 

Esteemed Advisor
Posts: 5,194

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

Sorry, I don't understand your issue.

Please post some sample input and desired output data.

Data never sleeps
Contributor
Posts: 51

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

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 1Column 2
25JAN2014:00:06:13.000000Y
25JAN2014:00:08:32.000000Y
25JAN2014:00:14:15.000000Y
25JAN2014:00:18:39.000000Y
25JAN2014:00:18:40.000000Y
26JAN2014:14:58:33.000000Y
26JAN2014:14:58:47.000000Y
26JAN2014:14:59:18.000000Y
26JAN2014:15:01:15.000000Y
27JAN2014:00:01:10.000000Y
27JAN2014:00:03:46.000000Y
27JAN2014:00:00:00.000000Y
27JAN2014:00:00:00.000000Y
28JAN2014:00:00:00.000000Y
28JAN2014:00:00:00.000000Y
28JAN2014:00:00:00.000000Y
28JAN2014:00:00:00.000000Y
29JAN2014:00:00:00.000000Y
29JAN2014:00:00:00.000000Y
29JAN2014:00:00:00.000000Y
30JAN2014:00:00:00.000000Y
30JAN2014:00:00:00.000000Y
30JAN2014:00:00:00.000000Y
Esteemed Advisor
Posts: 5,194

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

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.

Data never sleeps
Contributor
Posts: 51

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

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

Esteemed Advisor
Posts: 5,194

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

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

Data never sleeps
Super Contributor
Posts: 282

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

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.

Community Manager
Posts: 2,691

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

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

Contributor
Posts: 51

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

That worked. Thank you Amir.

Chris,

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

Regards

Sharath

Contributor
Posts: 26

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

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

Ask a Question
Discussion stats
  • 9 replies
  • 481 views
  • 0 likes
  • 5 in conversation