I have a table like this:
Week:
1
2
3
And another table like this:
Key Prod
23 A
23 B
24 A
24 B
I want to create table :
Week Key Prod
1 23 A
1 23 B
1 24 A
1 24 B
and like this for all weeks.
data Week;
input week;
datalines;
1
2
3
;
data prod;
input Key Prod $;
datalines;
23 A
23 B
24 A
24 B
;
proc sql;
create table want as
select * from week,prod;
quit;
run;
data Week;
input week;
datalines;
1
2
3
;
data prod;
input Key Prod $;
datalines;
23 A
23 B
24 A
24 B
;
proc sql;
create table want as
select * from week,prod;
quit;
run;
If your week data set is only incremented integer you can use this also without SQL:
data test1;
input x y$;
datalines;
23 A
23 B
24 A
24 B
;
data all;
set test1;
do week = 1 to 5 by 1;
output;
end;
run;
proc sort data=all;
by week;
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.