DATA Step, Macro, Functions and more

re: holiday function

Accepted Solution Solved
Reply
Regular Contributor
Posts: 222
Accepted Solution

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;

View solution in original post


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: 91

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: 9,662

Re: re: holiday function

data _null_;
x=NWKDOM(1, 2, 8, 2016);
put x= date9.;
run;
☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 291 views
  • 0 likes
  • 4 in conversation