topic How to extract all Saturday's dates from one particular Month ? in SAS Programming

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

Spintu — Mon, 26 Mar 2018 08:03:00 GMT

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

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

PeterClemmensen — Mon, 26 Mar 2018 08:09:39 GMT

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;

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

Spintu — Mon, 26 Mar 2018 08:20:20 GMT

Much appreciated your quick help.

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

PeterClemmensen — Mon, 26 Mar 2018 08:23:14 GMT

Anytime, glad to help.