turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Find a Community

- Home
- /
- BI
- /
- Enterprise Guide
- /
- how to start the calculation on a column having da...

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-05-2014 04:24 AM

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-05-2014 05:25 AM

Sorry, I don't understand your issue.

Please post some sample input and desired output data.

Data never sleeps

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-05-2014 05:36 AM

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 |

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-05-2014 06:27 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-05-2014 06:31 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-05-2014 06:34 AM

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

Data never sleeps

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-05-2014 08:33 AM

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.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-05-2014 08:38 AM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

02-05-2014 08:58 AM

That worked. Thank you Amir.

Chris,

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

Regards

Sharath

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content

12-11-2014 11:10 AM

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