topic Re: Generate hourly SLA for last 14 hours excluding holiday and weekend if any comes between in SAS Programming

Generate hourly SLA for last 14 hours excluding holiday and weekend if any comes between

Sukhi1 — Wed, 19 Jul 2023 17:02:45 GMT

Hi all, I want to generate a program which will work as per my SLA time. I have a created a format which will tell if a particular date is fall in holiday/weekend. Here is the data I want to print excluding weekend and holiday. my program will run 4 times a day ,7AM , 11AM, 2PM and 4PM. each time I want output like below. for date 18/07/23. either I need 14 row or 17 row

7AM 11AM 2PM 4PM

18/07/23 08:00AM 18/07/23 11:00AM   18/07/23 02:00PM 18/07/23 04:00PM
17/07/23 04:00PM 18/07/23 10:00AM 18/07/23 01:00PM 18/07/23 03:00PM
17/07/23 03:00PM 18/07/23 09:00AM   18/07/23 12:00PM 18/07/23 02:00PM
17/07/23 02:00PM 18/07/23 08:00AM 18/07/23 11:00AM 18/07/23 01:00PM
17/07/23 01:00PM 17/07/23 04:00PM 18/07/23 10:00AM 18/07/23 12:00PM
17/07/23 12:00PM 17/07/23 03:00PM   18/07/23 09:00AM    18/07/23 11:00AM
17/07/23 11:00AM 17/07/23 02:00PM   18/07/23 08:00AM    18/07/23 10:00AM
17/07/23 10:00AM 17/07/23 01:00PM 17/07/23 04:00PM 18/07/23 09:00AM
17/07/23 09:00AM 17/07/23 12:00PM   17/07/23 03:00PM 18/07/23 08:00AM
17/07/23 08:00AM 17/07/23 11:00AM   17/07/23 02:00PM 17/07/23 04:00PM
14/07/23 04:00PM 17/07/23 10:00AM 17/07/23 01:00PM 17/07/23 03:00PM
14/07/23 03:00PM 17/07/23 09:00AM 17/07/23 12:00PM 17/07/23 02:00PM
14/07/23 02:00PM 17/07/23 08:00AM 17/07/23 11:00AM 17/07/23 01:00PM
14/07/23 01:00PM 14/07/23 04:00PM 17/07/23 10:00AM 17/07/23 12:00PM

Please help me create this.

Need better subject line

PaigeMiller — Wed, 19 Jul 2023 11:57:20 GMT

Please go back and edit your post and change the subject line to something that actually briefly describes the problem. This helps everyone find posts of interest. If every post had a subject of "sas programming", no one would be able to find posts of interest and the community would be much less useful.

Re: sas programing

ballardw — Wed, 19 Jul 2023 14:32:24 GMT

Please don't make us count rows to determine what is needed, list or highlight the text somehow, I'm too lazy to count. And why either row 14 or 17? Programs need to have a pretty clear description of the requirement to create should be.

I have a hard time understanding what you expect. You talk about holiday/weekday but those would not change if the program runs at different times of a day.

If by a 'format which will tell if a particular date is fall in holiday/weekend' you mean something created in Proc Format then it likely wouldn't hurt to share that with us.

Which Holidays? Holidays are to some extent national in nature.

You have not even shared if those supposed values are a single variable, multiple variables or what. Where doe they come from?

I suspect that your problem discussion is missing a detail or two of you have and what you are expecting a program to generate.

General comment on discussing dates: Do not use 2-digit dates. I am not sure if you are showing values for 23 July 2018 or 18 July 2023.

Re: Generate hourly SLA for last 14 hours excluding holiday and weekend if any comes between

PaigeMiller — Wed, 19 Jul 2023 18:06:34 GMT

Thank you for changing the subject line. This helps everyone.

You didn't say this in your problem description, but your data implies that the results cannot be on a Saturday or Sunday? Is that correct? If so, please state conditions clearly in the problem description from now on.

Try this:

data what_times;
    now=datetime();
    nearest_hour=dhms(datepart(now),hour(timepart(now)),0,0);
    /* Loop and output hours and dates */
    count=0;
    this_hour=nearest_hour;
    do while(count<=14);
        this_hour=intnx('hour',this_hour,-1,'b');
        if 8<=hour(timepart(this_hour))<=16 /* Only output hours 8 through 16 */
            and weekday(datepart(this_hour)) not in (1,7) /* Only output if day of week is 2-6 (Monday thru Friday) */
            then do; 
            output;
            count=count+1;
        end;
    end;    
    format nearest_hour this_hour datetime16.;
run;

Re: Generate hourly SLA for last 14 hours excluding holiday and weekend if any comes between

Sukhi1 — Thu, 20 Jul 2023 06:40:01 GMT

Thank you so much. This what I was looking for. You can't believe how much you helped me by doing this. Thanks again