## Changing week variable

Solved
Occasional Contributor
Posts: 14

# 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,471

## 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;
```

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

## 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.