How to extract all Saturday's dates from one particular Month ?

[Spintu]

Hi Experts,

Could you please suggest me I want extract all Saturday's dates  from one beginning date of the month till last date of the same month.

So that I can automate the SAS Job. Right Now manually we are passing values,but going forward it has to be automate.

For example:

If creating Macro variable

%let sub_table_date='01MAR2018'd

I need to extract all Saturdays date till 31 Mar 2018. (endpoint we have to automate.)

so that we can extract 03Mar, 10Mar,17Mar,24mar,31mar.

Regards,

Purna

[PeterClemmensen · Accepted solution]

Do something like this.

data want;
	sub_table_date='01MAR2018'd;
	end_date=intnx('month', sub_table_date, 0, 'e');

	do date=sub_table_date to end_date;
		if weekday(date)=7 then output;
	end;

	format date date9.;
	keep date;
run;

[Spintu]

Much appreciated your quick help.

[PeterClemmensen]

Anytime, glad to help.