2nd working day of every month macros

vnreddy — Tue, 05 Jul 2022 16:57:17 GMT

Hi,

Could someone help me with any macros that i can use to schedule the report on 2nd working day of every month for UK

Thanks,

vnreddy

Re: 2nd working day of every month macros

sbxkoenk — Tue, 05 Jul 2022 18:06:19 GMT

Hello,

Are you using SAS 9.4 or SAS VIYA 3.5 or SAS VIYA 4?

There are several ways to achieve this (as always 😉 ).

First thing might be to identify the 2nd working day of every month.

Here are some examples that you can use as a start :

/* FIRST MONDAY of the MONTH */
data _NULL_;
  file print;
  year = year(today());
  do month = 1 to 12;
    firstDayMonth = mdy(month, 1, year);
    firstWorkDay  = NWKDOM(1, 2, month, year);
    PUT @1  firstDayMonth= weekdate.;
	PUT @50 firstWorkDay = weekdate.;
  end;
run;

/* second to last working day of the month                                */
/* Add HOLIDAYTEST Function (!!) to check if there's any holiday involved */
data _NULL_;
 file print;
  year = year(today());
  do month = 1 to 12;
    lastDay=intnx('weekday',intnx('month',mdy(month, 1, year),0,'E'),-1);
    PUT @1  lastDay= weekdate.;
  end; 
run;
/* end of program */

Thanks,

Koen

Re: 2nd working day of every month macros

SASKiwi — Thu, 07 Jul 2022 00:34:07 GMT

Why do you need to use a SAS macro when a scheduling tool can do this without any coding? Ask your SAS administrator about this.

topic 2nd working day of every month macros in SAS Programming

2nd working day of every month macros

Re: 2nd working day of every month macros

Re: 2nd working day of every month macros