topic Re: First Day (Date) of a Week and Last Day (Date) of a Week by Week number in SAS Programming

First Day (Date) of a Week and Last Day (Date) of a Week by Week number

Jasonnyc — Wed, 09 Apr 2014 22:29:00 GMT

Hi All--

I have a date variable which I use to identify the year week number by so a value of 1 to 52.

data want;

set have;

weeknum=week(date,'u');

run;

Notice notice my week starts on Sunday indicated by 'u'

What I also need and I can't figure out how to do is the actual first day of the week date and the date of the last day of the week.

data want;

set have;

weeknum=week(date,'u');

weekstart_dt=?????

weekend_dt=?????

run;

Any feedback/assistance will be much appreciated.

Thanks!

Re: First Day (Date) of a Week and Last Day (Date) of a Week by Week number

RichardinOz — Wed, 09 Apr 2014 22:51:33 GMT

Try

weekstart_dt=intnx('WEEK', '01JAN2014'D, weeknum) ;

weekend_dt=intnx('WEEK', '01JAN2014'D, weeknum, 'END') ;

Richard

Re: First Day (Date) of a Week and Last Day (Date) of a Week by Week number

data_null__ — Wed, 09 Apr 2014 22:52:46 GMT

data _null_; 
   x=today();
   b=intnx('week',x,0,'B');
   e=intnx('week',x,0,'E');
   format _all_ weekdate30.; 
   put (_all_)(=);
   run; 

15         data _null_;
16            x=today();
17            b=intnx('week',x,0,'B');
18            e=intnx('week',x,0,'E');
19            format _all_ weekdate30.; 
20            put (_all_)(=);
21            run;

x=Wednesday, April 9, 2014 b=Sunday, April 6, 2014 e=Saturday, April 12, 2014