## getting week number from middle of year to next middle of year

Solved
Super Contributor
Posts: 409

# getting week number from middle of year to next middle of year

Hi, is there a creative way to get week number of a dataset that has a process date that starts from March2016 to March2017.. so the frist week of March2016 is 1 and so on until 52 of the last week of March2017.  Not necessarily March, any month of the year, and if I only have 6 months then would have week 1 to week 26...etc.   Thanks

Accepted Solutions
Solution
‎05-05-2017 06:29 AM
PROC Star
Posts: 8,150

## Re: getting week number from middle of year to next middle of year

```data have;
format date date9.;
do date='1mar2016'd to '01mar2017'd;
output;
end;
run;

data want;
set have;
week=intck("week",'01mar2016'd,date);
run;
```

Art, CEO, AnalystFinder.com

All Replies
Solution
‎05-05-2017 06:29 AM
PROC Star
Posts: 8,150

## Re: getting week number from middle of year to next middle of year

```data have;
format date date9.;
do date='1mar2016'd to '01mar2017'd;
output;
end;
run;

data want;
set have;
week=intck("week",'01mar2016'd,date);
run;
```

Art, CEO, AnalystFinder.com

☑ This topic is solved.

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

Discussion stats