BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Spintu
Quartz | Level 8

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

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
PeterClemmensen
Tourmaline | Level 20

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;

 

 

View solution in original post

3 REPLIES 3
PeterClemmensen
Tourmaline | Level 20

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
Quartz | Level 8
Much appreciated your quick help.

sas-innovate-2024.png

Today is the last day to save with the early bird rate! Register today for just $695 - $100 off the standard rate.

 

Plus, pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1727 views
  • 2 likes
  • 2 in conversation