topic Re: Every Month 5th day of week in SAS Programming

Every Month 5th day of week

BrahmanandaRao — Thu, 09 May 2019 08:10:41 GMT

data wwk;
do weekday ='01-Jan-2019'd to'31-Dec-2019'd ;
 if weekday =1 then output  ;
end;
format weekday date9.;
run;

i want output like

DATE	Weekday
05-01-2019	Saturday
05-02-2019	Tuesday
05-03-2019	Tuesday
05-04-2019	Friday
05-05-2019	Sunday
05-06-2019	Wednesday
05-07-2019	Friday
05-08-2019	Monday
05-09-2019	Thursday
05-10-2019	Saturday
05-11-2019	Tuesday
05-12-2019	Thursday

Re: Every Month 5th day of week

ErikLund_Jensen — Thu, 09 May 2019 08:37:57 GMT

Hi @BrahmanandaRao

Try this. It is a bit more effecient, as it loops over months and not over days (12 vs. 365).


data wrk (drop=start end i);
	format date ddmmyyd10.;
	start = '01-Jan-2019'd;
	end = '31-Dec-2019'd ;
	do i = 0 to intck('month',start,end);
		Date = intnx('month',start,i)+4;
		Weekday = left(put(date,downame.));
		output;
	end;
run;

Re: Every Month 5th day of week

Jagadishkatam — Thu, 09 May 2019 09:00:35 GMT

data wwk;
do date ='01Jan2019'd to'31Dec2019'd ;
 if day(date) =5 then output  ;
 weekday=weekday(date);
end;
format date date9. weekday DOWNAME9.;
run;

Re: Every Month 5th day of week

ShiroAmada — Thu, 09 May 2019 09:05:54 GMT

Make it simpler using MDY function and a do loop.

data high_five;
  do year=2019 to 2020;
    do month=1 to 12;
	  weekday=mdy(month,5,year);
	  format weekday date9.;
	  output;
	end;
  end;
run;

Re: Every Month 5th day of week

BrahmanandaRao — Thu, 09 May 2019 09:48:44 GMT

Jagadish not getting desired output as per 2019 year