topic How to merge the data to create multiple records? in SAS Programming

How to merge the data to create multiple records?

munitech4u — Thu, 25 Sep 2014 11:06:51 GMT

I have a table like this:

Week:

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 — Thu, 25 Sep 2014 12:02:06 GMT

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 — Thu, 25 Sep 2014 12:26:53 GMT

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;