Hi, I would like to calculate time difference between two timestamps(datetime) during business hours only(8:00AM to 6:00PM), excluding public holidays and week ends. public holidays list is saved in a dataset or as a list in a macro variable value. for example, starting time is 30DEC2014:15:30:00 and ending time is 05JAN2015:09:52:00. In this case 01Jan2015 is public holiday and 3rd & 4th Jan15 are week end. Therefore, time difference I want to calculate is 2:30(on 30th Dec14) + 10:00(on 31st Dec14) + 10:00(on 2nd Jan15)  + 1:52(on 5th Jan15) =24:22 However, starting and/or ending time may be earlier than 8:00AM and/or later than 6:00PM. Still, I am only interested in time duration during business hours. Can any one help me to implement an efficient logic for the time calculation please. Many thanks inadvance, Hari ... View more

Hi, I am new to SAS and came across some SAS code.It is working fine. But feel difficulty in understanding the flow of SAS code. Could any one explain the flow of this %DO,IF and %DO %WHILE loops....how and when IF condition is getting executed with this %DO %WHILE and Macro variables? %do trig_i=1 %to &trig_count.;     if 1 eq 1              %let trig_j=1;              %let trig=%scan(&&trigc&trig_i,&trig_j,%str(;));           %do %while(&trig ne %str());           AND find(rules_comb_org,"&trig;")>0                     %let trig_j=%eval(&trig_j+1);                     %let trig=%scan(&&trigc&trig_i,&trig_j,%str(;));           %end;      then do;              rules_c="&&trigc&trig_i";              rules_num=&&trigh&trig_i;      end; %end; ... View more