DATA Step, Macro, Functions and more

How to increment week number every 7 days

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 12
Accepted Solution

How to increment week number every 7 days

[ Edited ]

Hi,

I would like to increment the week number by 1 every 7 days, starting from Apr 4 to "some end date".

My dataset looks like this:

Datepcode
4-Apr-14V5C0B3
4-Apr-14V5C0B4
5-Apr-14V5C0B3
5-Apr-14V5C0B4
6-Apr-14V5C0B3
6-Apr-14V5C0B4
7-Apr-14V5C0B3
7-Apr-14V5C0B4
8-Apr-14V5C0B3
8-Apr-14V5C0B4
9-Apr-14V5C0B3
9-Apr-14V5C0B4
10-Apr-14V5C0B3
10-Apr-14V5C0B4
11-Apr-14V5C0B3
11-Apr-14V5C0B4
12-Apr-14V5C0B3
12-Apr-14V5C0B4
13-Apr-14V5C0B3
13-Apr-14V5C0B4
14-Apr-14V5C0B3
14-Apr-14V5C0B4
15-Apr-14V5C0B3
15-Apr-14V5C0B4
16-Apr-14V5C0B3
16-Apr-14V5C0B4
17-Apr-14V5C0B3
17-Apr-14V5C0B4
18-Apr-14V5C0B3
18-Apr-14V5C0B4
19-Apr-14V5C0B3
19-Apr-14V5C0B4

 

and I want it to look like this:

DatepcodeWEEK
4-Apr-14V5C0B31
4-Apr-14V5C0B41
5-Apr-14V5C0B31
5-Apr-14V5C0B41
6-Apr-14V5C0B31
6-Apr-14V5C0B41
7-Apr-14V5C0B31
7-Apr-14V5C0B41
8-Apr-14V5C0B31
8-Apr-14V5C0B41
9-Apr-14V5C0B31
9-Apr-14V5C0B41
10-Apr-14V5C0B31
10-Apr-14V5C0B41
11-Apr-14V5C0B32
11-Apr-14V5C0B42
12-Apr-14V5C0B32
12-Apr-14V5C0B42
13-Apr-14V5C0B32
13-Apr-14V5C0B42
14-Apr-14V5C0B32
14-Apr-14V5C0B42
15-Apr-14V5C0B32
15-Apr-14V5C0B42
16-Apr-14V5C0B32
16-Apr-14V5C0B42
17-Apr-14V5C0B32
17-Apr-14V5C0B42
18-Apr-14V5C0B33
18-Apr-14V5C0B43
19-Apr-14V5C0B33
19-Apr-14V5C0B43

 

Thanks in advance!


Accepted Solutions
Solution
‎11-27-2015 07:44 PM
Super User
Posts: 5,499

Re: How to increment week number every 7 days

Posted in reply to lai302120

I have to assume you made a slight error in your post and that April 18 would increment to week=3.  Here's a statement you could add to your DATA step:

 

week = 1 + int( (date - '04apr2014'd) / 7);

 

Good luck.

View solution in original post


All Replies
Solution
‎11-27-2015 07:44 PM
Super User
Posts: 5,499

Re: How to increment week number every 7 days

Posted in reply to lai302120

I have to assume you made a slight error in your post and that April 18 would increment to week=3.  Here's a statement you could add to your DATA step:

 

week = 1 + int( (date - '04apr2014'd) / 7);

 

Good luck.

Occasional Contributor
Posts: 12

Re: How to increment week number every 7 days

Posted in reply to Astounding

thanks!!

🔒 This topic is solved and locked.

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

Discussion stats
  • 2 replies
  • 225 views
  • 0 likes
  • 2 in conversation