Creating Week Number in each observation

[DavidLie]

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

[stat_sas · Accepted solution]

Please try this.

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