topic Replicate results across rows in New SAS User

Replicate results across rows

dion_y — Fri, 22 Mar 2019 13:27:39 GMT

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 — Fri, 22 Mar 2019 13:32:26 GMT

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 — Fri, 22 Mar 2019 14:50:22 GMT

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 — Tue, 26 Mar 2019 12:12:41 GMT

Thanks and it works.