As for you calculation of hours, IF you are assuming 24 valid hours in each workday, and that start and end will ALWAYS be workdays, then you could use something like: DATA EXAMPLE;   START = '05APR2014:09:00:00'DT;   END    = '08APR2014:10:25:16'DT;   DAYS= INTCK('DAYS', DATEPART(START), DATEPART(END));            WEEKDAYS = INTCK('WEEKDAYS', DATEPART(START), DATEPART(END));   if days lt 1 then Turnaound_Time_In_Hours=(timepart(end)-    timepart(start)/(60*60));   else do;     Turnaound_Time_In_Hours=(24*60*60-timepart(start)+(weekdays-1)*      (24*60*60)+timepart(end))/(60*60);   end; RUN; That will produce a calculation of 49.42 hours for your example. ... View more

In excel the point is ARIAL. I am using BASE SAS 9.2 ... View more

No need for macro variables to do that logic.  You can read directly from the source table by using POINT= option on SET statement. DATA SMLS.CA1;   SET SMLS.CA;   HOLIDAY = 0;   DO p=1 to nobs ;     SET SMLS.HOLIDAYS(keep=HOLIDATE) point=p nobs=nobs ;     IF DATEPART(LAST_UPDATE_DATE) < HOLIDATE AND DATEPART(FIRST_UPDATE_DATE) > HOLIDATE        THEN HOLIDAY = HOLIDAY + 1     ;   END;   IF HOLIDAY >=1 THEN SLA = SLA - (24*HOLIDAY);   DROP HOLIDATE RUN; ... View more

Hi hellind As the requirement seems to be a support based do you guys work on weekends and holidays. Or else we can include few conditions like weekday() for discarding weekends support. Please find the updated code below... hope it helps data _null_; length x $20.; retain slastart 0; /***start of sla request***/ day=sum(date(),1); time=time(); /***ending the sla****/ enddate=sum(day,3); endtime=time(); slastrdt=dhms(day,0,0,time); slaenddt=dhms(enddate,0,0,time); /***************WEEK DAY Processing***************/ weekdy=weekday(day); if weekdy ge 2 and weekdy le 6 then    dtdiff=intck('day',day,sum(day,1));     else if weekdy in (1,7) then do;    select(weekdy);      when(1) if weekday(enddate) not in (1,7) then do;                    dtdiff=intck('day',day,sum(day,1))-1;     end;   when(7) if weekday(enddate) not in (1,7) then do;                    dtdiff=intck('day',day,sum(day,1))-2;     end;   otherwise put "error occured";   end; end; /***************WEEK DAY Processing***************/ hrstr=min(max(hour(slastrdt),9),16); hrend=min(max(hour(slaenddt),9),16); /****please change this*****/ dtdiff=intck('day',day,sum(day,1)); /****************************/     select(hrstr);    when(9)   hrstr=7;    when(10) hrstr=6;    when(11) hrstr=5;    when(12) hrstr=4;    when(13) hrstr=3;    when(14) hrstr=2;    when(15) hrstr=1;    when(16) hrstr=0;    otherwise put"error occured"; end; select(hrend);    when(9)   hrend=0;    when(10) hrend=1;    when(11) hrend=2;    when(12) hrend=3;    when(13) hrend=4;    when(14) hrend=5;    when(15) hrend=6;    when(16) hrend=7;    otherwise put"error occured"; end; if dtdiff eq 1 then sla=sum(hrstr,hrend); else if dtdiff ge 2 then sla=sum(hrstr,hrend,(dtdiff-1)*7); put sla=; run; Thank You ... View more

In the sample code you provided you are converting data type from date to character. If you just select the field you need without conversion:          SELECT    CA_NUMBER,                           SUBMISSION_DATE           FROM ... you will have SUBMISSION_DATE as date if it is date in database. ... View more

You can do that with SAS Enterprise Guide.  See: Tool>Options>SAS Programs. ... View more

My company has provided me with SAS Metadata Server username/password and EG to connect to. But I don't want to use EG. I can connect to this server from JMP. I am using SAS 9.2. How do I connect to the server from SAS 9.2? ... View more

How would the code look like to 'move the subquery where clause to the outer query'? By the way, the As_Of_Dt is many end of months (EOM). But in my example I only showed 2 EOM. ... View more

If you want to use your own SQL (OLEDB specific), you have to use explicit pass through. Which means that first you have to connect to your OLEDB data source, then enclose your SQL in either an execute block (if your SQL does not return any values to the SAS session, which is the case when creating permanent tables in the source database), or in a "from connection to" block, which is refferre3d to in a SAS SQL from statement. This however does not use any of the built in logic in EG. You could probably recreate some parts of the SQL by using the Query Builder. it has an option that will create the necessary SQL pass-thru specific code for you. /Linus ... View more

I'd actually find two feeds helpful: one for answered questions and another for unanswered questions. ... View more