3rd Thursday of the next month

[abbygrover]

I have the 3rd thursday of each month calculated, however, I need it to be the next month. when I do m+1, and the month is December, it will not show January to the following year.

data want (drop= y m);
format iss_date mmddyy.;

do y = year(today());
do m = month(today()) ;
iss_date=nwkdom(3,5,m,y);
output;
end;
end;
run;

[PeterClemmensen · Accepted solution]

This will give you the third Thursday of next month

data _null_;
   dt = intnx('week.5', intnx('month',today(),0,'e'), 3, 'b');
   format dt date9.;
   put dt;
run;

[abbygrover]

THANK YOU!!!