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
Please try this.
data want;
set have;
do week=1 to 52;
output;
end;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.