How to merge the data to create multiple records?

Accepted Solution Solved
Reply
Regular Contributor
Posts: 187
Accepted Solution

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
Trusted Advisor
Posts: 1,203

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;

View solution in original post


All Replies
Solution
‎09-25-2014 08:02 AM
Trusted Advisor
Posts: 1,203

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.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 181 views
  • 0 likes
  • 3 in conversation