topic Re: How to generate A* B records in SAS Programming

How to generate A* B records

walterwang — Fri, 30 Jul 2021 00:25:52 GMT

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.

Re: How to generate A* B records

ballardw — Fri, 30 Jul 2021 00:33:20 GMT

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.