Changing week variable

[claireluen]

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.

[Quentin · Accepted solution]

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;