re: holiday function

[twildone]

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.

[mohamed_zaki]

macro to get first monday?????? 

[mohamed_zaki · Accepted solution]

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

[advoss]

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

[Ksharp]

data _null_;
x=NWKDOM(1, 2, 8, 2016);
put x= date9.;
run;