Desktop productivity for business analysts and programmers

Changing week variable

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

Changing week variable

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.


Accepted Solutions
Solution
‎05-28-2014 01:41 PM
PROC Star
Posts: 1,291

Re: Changing week variable

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


All Replies
Solution
‎05-28-2014 01:41 PM
PROC Star
Posts: 1,291

Re: Changing week variable

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;
🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

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