topic Re: Every Month Second Saturday in a Year in SAS Programming

Every Month Second Saturday in a Year

BrahmanandaRao — Mon, 16 Aug 2021 08:00:26 GMT

title 'Find Second Saturday for Every Month in the Given Year'
data wrk (drop=start end i);
	format date ddmmyyd10.;
	start = '01-Jan-2021'd;
	end =   '31-Dec-2021'd ;
	do i = 1 to intck('month',start,end);
		Date = nwkdom(2,i,start,end);
 		Weekday = left(put(date,downame.)); 
		output;
	end;
run;

Re: Every Month Second Saturday in a Year

Patrick — Mon, 16 Aug 2021 08:09:48 GMT

Date = nwkdom(2,7,i,year(start));

...and for this to work for more than one year:

Date = nwkdom(2,7,i,year(intnx('month',start,i-1)));

Re: Every Month Second Saturday in a Year

BrahmanandaRao — Mon, 16 Aug 2021 11:11:35 GMT

data ss (drop=start end i);
format date ddmmyyd10. ;
start='01-Jan-2020'd ;
end=  '31-Dec-2021'd ;
 do i =1 to intck('month',start,end);
 date=nwkdom(2,7,i,year(intnx('Month','Start',i-1)));
 weekday=left(put(date,downame.));
 output; ;
 end;

run;

For Multiple Years its not give proper output

Re: Every Month Second Saturday in a Year

BrahmanandaRao — Tue, 17 Aug 2021 16:41:30 GMT

Any one fix the above error

Re: Every Month Second Saturday in a Year

Patrick — Wed, 18 Aug 2021 01:46:33 GMT

@BrahmanandaRao wrote:
Any one fix the above error

May-be copy the code I've suggested correctly. Right now your code returns all missings.

What might create below log message using your code?

NOTE: Invalid numeric data, 'Start' , at line 34 column 42.