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

[Jasonnyc]

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! 

[RichardinOz]

Try

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

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

Richard

[data_null__]

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