topic Re: where start_date1>=(today()-weekday(today())+2) - 7*156 --- ?? in SAS Programming

where start_date1>=(today()-weekday(today())+2) - 7*156 --- ??

sandeepgnv — Wed, 21 Dec 2016 10:33:46 GMT

Hi, I am new to SAS. I am trying to understand what the below code does.

where start_date1>=(today()-weekday(today())+2) - 7*156

Any help is much appreciated.

Thank you in advance.

Thanks,

Sandeepgnv

Re: where start_date1>=(today()-weekday(today())+2) - 7*156 --- ??

Kurt_Bremser — Wed, 21 Dec 2016 10:56:12 GMT

today()-weekday(today())+2

normalizes today's date to the last preceding Tuesday. Then 156 weeks are subtracted, which corresponds to rougly three years.

So it translates to "last Tuesday, three years ago".

Re: where start_date1>=(today()-weekday(today())+2) - 7*156 --- ??

RahulG — Wed, 21 Dec 2016 11:02:34 GMT

Code is going 3 years back by using factor 7*156 i.e. 7 * (3*52). It is kind of very unusual way to do.

(today()-weekday(today())+2) is kind of finding last Monday from current date.

You can try to use below code to debug it.


data temp;
format v1 v2  date9.;
v1=(today()-weekday(today())+2) - 7*156;
v2=(today()-weekday(today())+2);
v3=weekday(today());
v4=7*156;
v5=weekday(today())+2;
put _all_;
run;

Re: where start_date1>=(today()-weekday(today()) 2) - 7*156 --- ??

sandeepgnv — Wed, 21 Dec 2016 11:03:06 GMT

That was really quick 🙂
Many Thanks KurtBremser !!

##- Please type your reply above this line. Simple formatting, no
attachments. -##

Re: where start_date1>=(today()-weekday(today())+2) - 7*156 --- ??

Shmuel — Wed, 21 Dec 2016 11:03:19 GMT

today() function enters the system date into a variable.

Today you will get the DEC 12th, 2016 given in a sas date.

The sas date contains the number of days since JAN 1st, 1960.

weekday() function gives the day number in a week, IE:

1=sunday, 2=monday etc. or 1=monday, 2=tuesday, etc. - depending on your sas system.

Youe expression: where start_date1>=(today()-weekday(today())+2) - 7*156

means: check variable start_date1 is it greater or equal to the calculated date

(today - 4 (=wednsday) + 2) - 7*156.

To unswer, why is such calculation, you need ask the one who gave it to you.

Re: where start_date1>=(today()-weekday(today())+2) - 7*156 --- ??

SuryaKiran — Wed, 21 Dec 2016 14:31:25 GMT

This type of calculation dosen't give accurate value. Since 1 year ^= 365 days or 1 year ^= 52 weeks.