Replicate results across rows

[dion_y]

Hi there:  I want to copy data as follow:

Tbl_A        Tbl_B

10              40

20              50

..                ..

Desire outcome:

Tbl_C - 2 columns

10          40

10          50

20          40

20          50

Any suggestions?

[novinosrin]

data Tbl_A   ;
input A;
cards;
10
20
;

data Tbl_B   ;
input B;
cards;
40
50
;

proc sql;
create table Tbl_C as
select *
from Tbl_A,Tbl_B;
quit;

[Reeza]

The term for this would be a cross join or a Cartesian product. You'll likely see a SAS note to that effect in your log.

[dion_y]

Thanks and it works.