Are full join and cross join (cartesian product) same thing in SAS?

[GN0001]

Hello team,

Are full join and cross join (cartesian product) same thing in SAS?

Regards,

blueblue

[ChrisNZ]

> Are full join and cross join (cartesian product) same thing in SAS?

No there're not: A full join joins on key values.

Unless you omit the keys as in:

from TABLE1 full join TABLE2 on 1

which means that there is no join criterion and you create a cross join

[SASKiwi · Accepted solution]

By definition they are not the same at all regardless of what software you use to do them.