topic 3rd Thursday of the next month in SAS Enterprise Guide

3rd Thursday of the next month

abbygrover — Wed, 14 Dec 2022 19:18:05 GMT

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;

Re: 3rd Thursday of the next month

PeterClemmensen — Wed, 14 Dec 2022 19:22:57 GMT

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;

Re: 3rd Thursday of the next month

abbygrover — Wed, 14 Dec 2022 19:30:11 GMT

THANK YOU!!!