How to generate A* B records

[walterwang]

data dat1;
input x;
cards;
1
3
4
6
7
8
;
run;
data dat2;
input y;
cards;
1
4
3
6
7
5
;
run;

How to get the data include all combination of x and y?

that is:

x y

1 1
1 4
1 3
1 6
1 7
1 5

3 1
3 4
3 3
3 6
3 7
3 5....

thanks.

[ballardw · Accepted solution]

Proc Sql;
   create table want as
   select dat1.x, dat2.y
   from dat1, dat2
   ;
quit;

There will be a note in the log about a Cartesian join that cannot be optimized. Since you are requesting a Cartesian join, all records with all records, that note is okay.