topic Re: Weekends in SAS Enterprise Guide

Weekends

PavanKumar2 — Mon, 11 Feb 2019 07:06:17 GMT

Hi,

I have 2Dates.

Start-Date:01-01-2019

End-Date:01-02-2019

I need weekend dates between Start-Date and End-Date as

04-01-2019

11-01-2019

18-01-2019

25-01-2019

01-02-2019

Colud you please Help me

Re: Weekends

FredrikE — Mon, 11 Feb 2019 08:01:25 GMT

Try this 🙂

data _null_;
 do i = '01jan2019'd to '01feb2019'd;
   if weekday(i) = 6 then put i yymmdd10.;
 end;
run;

//Fredrik

Re: Weekends

Patrick — Mon, 11 Feb 2019 10:50:37 GMT

@PavanKumar2

If this is about shifting week-end dates to the date of the previous Friday then below code should do.

data sample;
 format calendar_date workingDate yymmdd10.;
 do calendar_date = '01jan2019'd to '01feb2019'd;
   workingDate=intnx('weekday',calendar_date,0,'b');
   output;
 end;
run;
proc print data=sample;
run;

Re: Weekends

Ksharp — Mon, 11 Feb 2019 12:43:33 GMT

data x;
do i=0 to intck('week','01jan2019'd, '01feb2019'd);
  date=intnx('week.7','01jan2019'd,i,'e');output;
end;
format date ddmmyy10.;
run;
proc print;run;