Changing week variable

claireluen — Wed, 28 May 2014 16:02:49 GMT

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.

Re: Changing week variable

Quentin — Wed, 28 May 2014 17:41:21 GMT

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;

topic Changing week variable in SAS Enterprise Guide

Changing week variable

Re: Changing week variable