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

Posts: 3,852

## 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
Discussion stats
• 2 replies
• 2648 views
• 0 likes
• 3 in conversation