sharath_rk Tracker

Re: What does PRXPARSE("/(\w)+(-)(\w)+/") mean? Does it mean to search for word with two characters??

sharath_rk — Wed, 09 Jul 2014 11:41:37 GMT

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.

What does PRXPARSE("/(\w)+(-)(\w)+/") mean? Does it mean to search for word with two characters??

sharath_rk — Wed, 09 Jul 2014 11:05:53 GMT

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

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

sharath_rk — Fri, 20 Jun 2014 14:32:02 GMT

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;

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

sharath_rk — Sun, 27 Apr 2014 03:28:03 GMT

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

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

sharath_rk — Fri, 25 Apr 2014 15:45:04 GMT

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

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

sharath_rk — Fri, 11 Apr 2014 13:57:09 GMT

Richard,

The code worked Thank you very much.

Regards

Sharath

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

sharath_rk — Thu, 10 Apr 2014 04:18:16 GMT

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

Re: Loop is not considering the condition

sharath_rk — Mon, 07 Apr 2014 15:01:01 GMT

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

Re: Loop is not considering the condition

sharath_rk — Fri, 04 Apr 2014 11:10:49 GMT

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.

Re: How to call custom holiday calendar in the calculations

sharath_rk — Fri, 04 Apr 2014 06:38:30 GMT

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;

Re: How to call custom holiday calendar in the calculations

sharath_rk — Thu, 03 Apr 2014 15:10:34 GMT

Team,

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

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

sharath_rk — Thu, 03 Apr 2014 15:08:17 GMT

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;

Re: How to limit the calculation to three business days excluding weekends

sharath_rk — Wed, 02 Apr 2014 15:15:49 GMT

It worked Thank you very much.

Re: How to limit the calculation to three business days excluding weekends

sharath_rk — Wed, 02 Apr 2014 14:58:45 GMT

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

Re: How to limit the calculation to three business days excluding weekends

sharath_rk — Wed, 02 Apr 2014 14:52:04 GMT

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';

How to call custom holiday calendar in the calculations

sharath_rk — Wed, 02 Apr 2014 12:34:26 GMT

Hello,

I have created a custom holiday calender per below. I need the below logic to look up the holiday calendar also along with weekday to give the desired output. Please advise.

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;

data EMEA_holidays_2014;

infile datalines truncover;

attrib

region informat=$5.

country informat=$25.

hol_date informat=date9. format=date9.;

input region Country hol_date;

datalines;

EMEA Russia 10MAR2014

EMEA Ukraine 10MAR2014

EMEA South_Africa 21MAR2014

EMEA Greece 25MAR2014

EMEA South_Africa 28MAR2014

EMEA Ireland 17APR2014

EMEA Slovakia 18APR2014

EMEA CPF 18APR2014

EMEA Switzerland 18APR2014

EMEA Portugal 18APR2014

EMEA Spain 18APR2014

EMEA EDB 18APR2014

EMEA South_Africa 18APR2014

EMEA Greece 18APR2014

EMEA UK 18APR2014

EMEA Italy 20APR2014

EMEA Hungary 21APR2014

EMEA UK 21APR2014

EMEA Greece 21APR2014

EMEA Switzerland 21APR2014

EMEA South_Africa 21APR2014

EMEA Austria 21APR2014

EMEA CPF 21APR2014

EMEA EDB 21APR2014

EMEA Ukraine 21APR2014

EMEA France 21APR2014

EMEA Slovakia 21APR2014

EMEA CzeSwitzerland_Repblic 21APR2014

EMEA Poland 21APR2014

EMEA Italy 21APR2014

EMEA Germany 21APR2014

EMEA Ireland 21APR2014

EMEA Portugal 24APR2014

EMEA Italy 25APR2014

EMEA South_Africa 25APR2014

EMEA South_Africa 28APR2014

EMEA Austria 01MAY2014

EMEA South_Africa 01MAY2014

EMEA Slovakia 01MAY2014

EMEA Portugal 01MAY2014

EMEA Poland 01MAY2014

EMEA Italy 01MAY2014

EMEA Hungary 01MAY2014

EMEA France 01MAY2014

EMEA Spain 01MAY2014

EMEA Germany 01MAY2014

EMEA CzeSwitzerland_Repblic 01MAY2014

EMEA Ireland 05MAY2014

EMEA UK 05MAY2014

EMEA EDB 05MAY2014

EMEA CPF 05MAY2014

EMEA Slovakia 08MAY2014

EMEA France 08MAY2014

EMEA CzeSwitzerland_Repblic 08MAY2014

;

run;

How to limit the calculation to three business days excluding weekends

sharath_rk — Wed, 02 Apr 2014 12:23:29 GMT

Hello,

I am needing to calculate three business days from OE_DATE & DLVR_STRT_DATE and using the below i am getting three business days between order date & delivery date. however if an order is placed on tuesday then i am getting three business days as wed, thu, fri, sat & sun. I need the sat & sun excluded from the calc as it is > 3 business days. The issue is with orders having order date on tuesdays where the made orders have delivery date on wed, thu, fri, sat & sun where delivery date on sat, sun should be miss as it is > 3 business days. Please advise.

IF intck('WEEKDAY',OE_DATE,DLVR_STRT_DATE) LE 3 then c = 'made'

else c = 'miss';

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

sharath_rk — Wed, 02 Apr 2014 12:12:02 GMT

Thank you all. The issue has been resolved using below.

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;

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

sharath_rk — Tue, 01 Apr 2014 11:37:53 GMT

Thank you Pradeep. I need the count of weekends for another calculation and in your code provided above is there a way to not enter datalines as i have 300,000 rows with diff dates between two columns and the third column should just give the total business days. Instead of datalines can i reference the data set.

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

sharath_rk — Tue, 01 Apr 2014 11:00:35 GMT

Pradeep,

Please see sample data below. i need the current total days column to give me the total business days between order dare & delivery date as per desired output. Please advise.

order date delivery date current total days desired output ( total days )

22MAR2014 24MAR2014 3 1 ( exclude 22 & 23 which are weekends )

23MAR2014 25MAR2014 3 2 exclude 23 weekend

21MAR2014 24MAR2014 4 2 exclude 22/23 weekend

20MAR2014 25MAR2014 6 4 exclude 22/23 weekend

23MAR2014 26AR2014 4 3exclude 23 weekend