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!
Try
weekstart_dt=intnx('WEEK', '01JAN2014'D, weeknum) ;
weekend_dt=intnx('WEEK', '01JAN2014'D, weeknum, 'END') ;
Richard
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.