When assigning week variables in SAS EG, how can I set a week as Thursday-Wednesday rather than the default Sunday-Saturday? Our production week begins on Thursday.
Hi,
How are you assingning week now? Assuming January 1st is not a Thursday, do you want a value of 0 until the first Thursday, and then increment week numbers after that?
Perhaps something like below, which counts how many Thursdays have passed since January first:
data have; do date="01Jan2014"d to "31Dec2014"d; output; end; format date mmddyy10.; run; data want; set have; weekNum=intck('week.5' ,intnx('year',date,0,'B')-1 ,date ); run; proc freq data=want; tables date*WeekNum/missing list; run;
Hi,
How are you assingning week now? Assuming January 1st is not a Thursday, do you want a value of 0 until the first Thursday, and then increment week numbers after that?
Perhaps something like below, which counts how many Thursdays have passed since January first:
data have; do date="01Jan2014"d to "31Dec2014"d; output; end; format date mmddyy10.; run; data want; set have; weekNum=intck('week.5' ,intnx('year',date,0,'B')-1 ,date ); run; proc freq data=want; tables date*WeekNum/missing list; run;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
Check out this tutorial series to learn how to build your own steps in SAS Studio.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.