topic Re: Calculating Business/Working days within EG or DI Studio in SAS Enterprise Guide

Calculating Business/Working days within EG or DI Studio

Cullima — Wed, 30 Apr 2008 15:50:52 GMT

I have an EG project that uses the intck function to create a new variable which calculates the number of 'weekdays' between two date variables in the source table. However, I need the result to take into account any public holidays which might fall between these two dates. This is something we have previously done in Excel using (e.g.) =NETWORKDAYS(A3,A4,Holidays), which was pretty straightforward. How can I acheive the same result in SAS Enterprise Guide or DI Studio?

Re: Calculating Business/Working days within EG or DI Studio

Doc_Duke — Wed, 30 Apr 2008 16:27:43 GMT

One way might be to use Peter Crawford's program on SAS-L

http://www.listserv.uga.edu/cgi-bin/wa?A2=ind9909d&L=sas-l&F=&S=&P=6817

Not as pretty as a function. You'd have to do it in a code task, but it will work.

Doc Muhlbaier
Duke

Re: Calculating Business/Working days within EG or DI Studio

Jay — Wed, 30 Apr 2008 17:39:00 GMT

Here's a link to a SAS Sample / note showing exactly what your trying to do:

http://support.sas.com/kb/26/044.html

Re: Calculating Business/Working days within EG or DI Studio

Cullima — Fri, 02 May 2008 10:37:19 GMT

Many thanks for your responses. Can someone please explain to me how I would go about applying the code to my EG project, given that I have two columns in my table, DATE_MADE and TEST_DATE, and want to create a new column which will calculate the number of holidays between the two with a view to taking this off the result of my intck function to obtain the total working days. I am not overly experienced in SAS code so would appreciate as much advice as possible.

Thanks