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

Reply
New Contributor
Posts: 3

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

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! 

Super Contributor
Posts: 644

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

Try

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

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


Richard

Respected Advisor
Posts: 3,777

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

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
Ask a Question
Discussion stats
  • 2 replies
  • 840 views
  • 0 likes
  • 3 in conversation