topic Re: re: holiday function in SAS Programming

re: holiday function

twildone — Thu, 21 Jan 2016 18:29:00 GMT

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.

Re: re: holiday function

mohamed_zaki — Thu, 21 Jan 2016 18:39:23 GMT

macro to get first monday??????

Re: re: holiday function

advoss — Thu, 21 Jan 2016 18:43:16 GMT

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

Re: re: holiday function

mohamed_zaki — Thu, 21 Jan 2016 19:02:23 GMT

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

Re: re: holiday function

Ksharp — Fri, 22 Jan 2016 04:46:39 GMT

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