How to merge the data to create multiple records?

Solved
Regular Contributor
Posts: 196

How to merge the data to create multiple records?

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.

Accepted Solutions
Solution
‎09-25-2014 08:02 AM
Posts: 1,270

Re: How to merge the data to create multiple records?

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;

All Replies
Solution
‎09-25-2014 08:02 AM
Posts: 1,270

Re: How to merge the data to create multiple records?

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;

Super Contributor
Posts: 490

Re: How to merge the data to create multiple records?

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;

🔒 This topic is solved and locked.