BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
claireluen
Calcite | Level 5

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Quentin
Super User

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;

View solution in original post

1 REPLY 1
Quentin
Super User

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;

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

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!

Register Now

Creating Custom Steps in SAS Studio

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1106 views
  • 0 likes
  • 2 in conversation