About sharath_rk

sharath_rk · ‎07-09-2014

Thank you Tom. I can relate to the expression now which is looking for a pattern in the data with one or more characters, followed by dash, followed by one or more characters.

sharath_rk · ‎07-09-2014

Does it mean to search for word with two charecters??

sharath_rk · ‎06-20-2014

Thank you. I found the solution using the below. A = B; datecount =0; do until(datecount > Business days ); ECR=ECR+1; if weekday(A) not in (1,7) AND A not in (&AMERHOL.) then datecount=datecount+1; end; END;

sharath_rk · ‎04-26-2014

Hai Kuo, Thank you for providing the code. i am getting business days excluding weekends/holidays in the data BSDAY however i am not clear on the code for DATA WANT as to how do i reference the actual data set(ABC) which has multiple rows & columns to add BUSINESSDAYS to ORDER_DATE. The dataset (ABC) has the columns ORDER_DATE & Business_Days along with other columns. How do i provide the data for Input using the actual columns in the dataset (ABC) instead of listing it out per below. NEW_OUTPUT_DATE column in the dataset (ABC) should give the business days added to the order_date. Please advise. CARDS; 2/22/2014 2 2/26/2014 2/24/2014 10 3/13/2014 2/26/2014 15 3/24/2013 2/28/2014 20 4/1/2014

sharath_rk · ‎04-25-2014

Team, I am needing to add business days to a date column ( Order_Date ) which should exclude weekends & holidays while adding the business days and the desired output should be date column. Please advise. In the below sample data, order_date is 02/22 (02/23 is weekend ) and 2 business days would be 2/25. Since 2/25 is a holiday, the output should be 02/26. The condition should exclude the weekend & holidays to give desired output. Holidays is a macro. Please assist. Order_Date Business Days Ship_Date Holidays Desired Output 2/22/2014 2 3/5/2014 2/25/2014 2/26/2014 2/24/2014 10 3/8/2014 2/27/2014 3/13/2014 2/26/2014 15 3/10/2014 3/4/2014 3/24/2013 2/28/2014 20 3/12/2014 3/7/2014 4/1/2014

sharath_rk · ‎04-11-2014

Richard, The code worked Thank you very much. Regards Sharath

sharath_rk · ‎04-10-2014

Team, In the below data i need the desired output in hours per below where 29th & 30th are weekends in which only weekend hours are to be excluded. In the first row the calculation should consider starting 31st mar 12:00AM till 31st mar 15:13:46.000000 which would be 15 hours. In the second row the calculation should start from 31st mar 12:00AM till 01APR2014:08:37:39 which would be 24 + 8 = 32 hours. Please advise how do i exclude the weekend hours to get the business hours between ORD_ENTRY_DATE & DLVR_STRT_DTS. ORD_ENTRY_DATE DLVR_STRT_DTS Desired Output In Hours 29MAR2014:00:06:17.000000 31MAR2014:15:13:46.000000 15 30MAR2014:00:32:39.000000 01APR2014:08:37:39.000000 32

sharath_rk · ‎04-07-2014

Thank you Pat. I will try custom interval approach as advised.

sharath_rk · ‎04-04-2014

Pat, Thank you. how can i call the variable EMEA_holidays_2014 in my calculation where the lookup need to consider weekends/AMERHOL/EMEA holidays and if order entry date is among any of these then c='miss'; Please advise.

sharath_rk · ‎04-04-2014

i am not able to call EMEA_holidays_2014 variable in the calculation. Is there a way to do it? the below code is the format i am looking to look up the order date for weekends & emea holidays list. SELECT (REGION); WHEN ('EMEA') DO; IF WEEKDAY(DATEPART(ORD_ENTRY_DATE)) NOT IN (1,7) & ORD_ENTRY_DATE not in EMEA_holidays_2014 then do c = 'made' ; else c = 'miss'; END;

sharath_rk · ‎04-03-2014

Team, Please advise whether it is possible to reference the custom calender?

sharath_rk · ‎04-03-2014

Hi, in the below code is there a way to include the hour/24 to get the difference in hours between OE_DATE to DLVR_STRT_DATE. For example : OE_DATE = 22MAR2014:00:03:29.000000 & DLVR_STRT_DATE = 25MAR2014:13:29:27.000000 means order placed at 12:03 and delivered at 13:29 I need the calc to exclude weekends & reduce the difference of hours in the weekend. data want; set have; weekend_days=0; if (ORD_ENTRY_DATE > .) and (DLVR_STRT_DATE > .) then do _n_=OE_DATE to DLVR_STRT_DATE; if weekday(_n_) in (1, 7) then weekend_days + 1; end; run;

sharath_rk · ‎04-02-2014

It worked Thank you very much.

sharath_rk · ‎04-02-2014

The duration between two date columns should be LE 3 business days.

sharath_rk · ‎04-02-2014

made = OE_DATE + 3 business days should be less than equal to DLVR_STRT_DATE minus weekends. Please advise. for example : OE_DATE = Tuesday + 3 business days ( wed, thu, fri ) less than equal to DLVR_STRT_DATE then c='made'; else c='miss'; the below logic works for all days except tuesday where made orders are from wed, thu, fri, sat & sun. IF intck('WEEKDAY',OE_DATE,DLVR_STRT_DATE) LE 3 then c = 'made' else c = 'miss';

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

Re: What does PRXPARSE("/(\w)+(-)(\w)+/") mean? Does it mean to searc...

What does PRXPARSE("/(\w)+(-)(\w)+/") mean? Does it mean to search fo...

Re: How To Add business days to a date column to get another date colu...

Re: How To Add business days to a date column to get another date colu...

How To Add business days to a date column to get another date column

Re: How To Count the number of weekends between two date columns

Re: How To Count the number of weekends between two date columns

Re: Loop is not considering the condition

Re: Loop is not considering the condition

Re: How to call custom holiday calendar in the calculations

Re: What does PRXPARSE("/(\w)+(-)(\w)+/") mean? Does it mean to searc...

Re: How To Add business days to a date column to get another date colu...

Re: How To Count the number of weekends between two date columns

Re: Loop is not considering the condition

Re: How To Count the number of weekends between two date columns

Re: What does PRXPARSE("/(\w)+(-)(\w)+/") mean? Does it mean to searc...

What does PRXPARSE("/(\w)+(-)(\w)+/") mean? Does it mean to search fo...

Re: How To Add business days to a date column to get another date colu...

Re: How To Add business days to a date column to get another date colu...

How To Add business days to a date column to get another date column

Re: How To Count the number of weekends between two date columns

Re: How To Count the number of weekends between two date columns

Re: Loop is not considering the condition

Re: Loop is not considering the condition

Re: How to call custom holiday calendar in the calculations

Re: How to call custom holiday calendar in the calculations

Re: How To Count the number of weekends between two date columns

Re: How to limit the calculation to three business days excluding week...

Re: How to limit the calculation to three business days excluding week...

Re: How to limit the calculation to three business days excluding week...