join with , in proc sql

GN0001 — Sat, 24 Jul 2021 04:25:29 GMT

Hello team,

I have received a code as this:

proc sql;

create table as

select a.field1, b.field2, b.field3

from a, b

quit

What kind of join does a, b represent? A Cartesian product?

Regards,

blueblue

Re: join with , in proc sql

jimbarbour — Sat, 24 Jul 2021 04:37:32 GMT

Yes. That is what your results set would be, a Cartesian product of the two tables.

Jim