DATA Step, Macro, Functions and more

Creating Week Number in each observation

Accepted Solution Solved
Reply
Contributor
Posts: 21
Accepted Solution

Creating Week Number in each observation

Hi SAS Community,

 

I have a total of 2500 unique customer numbers and I want to include the variable 'week' in each customer observation. I will outline this into tabular format below.

 

What do I have now?

Customer ID
EDDY
CHRIS
PETER
MALCOMN
DAVID
EVANS

 

What do I want?

Customer ID Week
EDDY 1
EDDY 2
EDDY 3
EDDY 4
EDDY 5
EDDY 6
EDDY 7
EDDY
EDDY 52
CHRIS 1
CHRIS 2
CHRIS 3
CHRIS 4
CHRIS 5
CHRIS 6
CHRIS 7
CHRIS
CHRIS 52
 
EVANS 1
EVANS 2
EVANS 3
EVANS 4
EVANS 5
EVANS 6
EVANS 7
EVANS
EVANS 52

 

Appreciate your help! Thanks.

 

Dave


Accepted Solutions
Solution
‎07-04-2016 12:47 AM
Trusted Advisor
Posts: 1,228

Re: Creating Week Number in each observation

Please try this.

 

data want;
set have;
do week=1 to 52;
    output;
end;
run;

View solution in original post


All Replies
Solution
‎07-04-2016 12:47 AM
Trusted Advisor
Posts: 1,228

Re: Creating Week Number in each observation

Please try this.

 

data want;
set have;
do week=1 to 52;
    output;
end;
run;

☑ This topic is solved.

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

Discussion stats
  • 1 reply
  • 201 views
  • 2 likes
  • 2 in conversation