get last available business date in previous month

[hdg]

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

[Reeza]

Do you need to account for holidays?

[hdg]

no just business days..thanks

[ballardw]

So which are your business days?

[hdg]

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

[Reeza · Accepted solution]

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;

[hdg]

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

[Reeza]

SASKiwi answer is preferable to mine, more efficient.

[SASKiwi]

Alternative way:

Data want;

Date = "21Feb2014"d;

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

format last_month_busday date9.;

run;