## re: holiday function

Solved
Regular Contributor
Posts: 247

# re: holiday function

Hi...Is there something similiar or equivalent to holiday('labor', year) but rather than producing the first Monday in September, the result would the first Monday in August? Thnaks.

Accepted Solutions
Solution
‎01-21-2016 08:10 PM
Super Contributor
Posts: 490

## Re: re: holiday function

[ Edited ]
``````data null;
year=2016;
month=8;
format monday date9.;
monday=intnx('week.3',(mdy(month,1,year)),0,'e');
run;``````

All Replies
Super Contributor
Posts: 490

## Re: re: holiday function

Solution
‎01-21-2016 08:10 PM
Super Contributor
Posts: 490

## Re: re: holiday function

[ Edited ]
``````data null;
year=2016;
month=8;
format monday date9.;
monday=intnx('week.3',(mdy(month,1,year)),0,'e');
run;``````
Frequent Contributor
Posts: 94

## Re: re: holiday function

If you are looking for the same day, one month prior to Labor day, you can do:

data _null_;

date_labor = holiday('LABOR',year(today()));

date_1MonthPrior = intnx('MONTH',date_labor,-1,'S');

format Date_: YYMMDD10.;

put _all_;

stop;

run;

date_labor=2016-09-05 date_1MonthPrior=2016-08-05 _ERROR_=0 _N_=1

Super User
Posts: 10,787

## Re: re: holiday function

``````data _null_;
x=NWKDOM(1, 2, 8, 2016);
put x= date9.;
run;``````
🔒 This topic is solved and locked.