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
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;
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;
Anytime, glad to help.
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
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.