topic Re: get last available business date in previous month in SAS Procedures

get last available business date in previous month

hdg — Thu, 20 Feb 2014 21:43:17 GMT

I have a dataset called myds which has the below columns date code I would like to add another column called prevmonthdate which is the last business date of the previous month Thanks, HD

Re: get last available business date in previous month

Reeza — Thu, 20 Feb 2014 21:44:43 GMT

Do you need to account for holidays?

Re: get last available business date in previous month

hdg — Thu, 20 Feb 2014 22:01:56 GMT

no just business days..thanks

Re: get last available business date in previous month

ballardw — Thu, 20 Feb 2014 22:11:41 GMT

So which are your business days?

Re: get last available business date in previous month

hdg — Thu, 20 Feb 2014 22:13:00 GMT

sorry for being so unclear long day.. i mean just monday to friday only week days

Re: get last available business date in previous month

Reeza — Thu, 20 Feb 2014 22:28:57 GMT

Probably a better way than this, specifically to check if its a Saturday/Sunday. I also believe this question is answered on here, so searching will probably get you a better response.

data have;

do i=1 to 12;

date=mdy(i, 15, 2014);

output;

end;

run;

data want;

set have;

last_business_day=intnx('month', date, -1, 'end');

if weekday(last_business_day) =1 then last_business_day=last_business_day-2;

else if weekday(last_business_day)=7 then last_business_day=last_business_day-1;

format date last_business_day date9.;

run;

Re: get last available business date in previous month

SASKiwi — Thu, 20 Feb 2014 22:57:57 GMT

Alternative way:

Data want;

Date = "21Feb2014"d;

last_month_busday = intnx('WEEKDAY', intnx('MONTH', date, -1, 'END'), 0);

format last_month_busday date9.;

run;

Re: get last available business date in previous month

hdg — Fri, 21 Feb 2014 15:03:17 GMT

THank you. Both answers are correct!! Thanks very much

Re: get last available business date in previous month

Reeza — Fri, 21 Feb 2014 17:55:13 GMT

SASKiwi answer is preferable to mine, more efficient.