How to merge the data to create multiple records?

[munitech4u]

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.

[stat_sas · Accepted solution]

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;

[mohamed_zaki]

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;