https://communities.sas.com/t5/SAS-Programming/Are-full-join-and-cross-join-cartesian-product-same-thing-in-SAS/m-p/758969#M239738 <P>By definition they are not the same at all regardless of what software you use to do them.</P> Tue, 03 Aug 2021 06:39:43 GMT SASKiwi 2021-08-03T06:39:43Z https://communities.sas.com/t5/SAS-Programming/Are-full-join-and-cross-join-cartesian-product-same-thing-in-SAS/m-p/758941#M239718 <P>Hello team,</P> <P>&nbsp;</P> <P>Are full join and cross join (cartesian product) same thing in SAS?</P> <P>&nbsp;</P> <P>Regards,</P> <P>blueblue</P> Tue, 03 Aug 2021 03:44:51 GMT https://communities.sas.com/t5/SAS-Programming/Are-full-join-and-cross-join-cartesian-product-same-thing-in-SAS/m-p/758941#M239718 GN0001 2021-08-03T03:44:51Z https://communities.sas.com/t5/SAS-Programming/Are-full-join-and-cross-join-cartesian-product-same-thing-in-SAS/m-p/758945#M239722 <P>&gt;&nbsp;<SPAN>Are full join and cross join (cartesian product) same thing in SAS?</SPAN></P> <P>No there're not: A full join joins on key values.</P> <P>Unless you omit the keys as in:</P> <P><FONT face="courier new,courier">from TABLE1 full join TABLE2 on 1</FONT></P> <P>which means that there is no join criterion and you create a cross join</P> Tue, 03 Aug 2021 04:27:23 GMT https://communities.sas.com/t5/SAS-Programming/Are-full-join-and-cross-join-cartesian-product-same-thing-in-SAS/m-p/758945#M239722 ChrisNZ 2021-08-03T04:27:23Z https://communities.sas.com/t5/SAS-Programming/Are-full-join-and-cross-join-cartesian-product-same-thing-in-SAS/m-p/758969#M239738 <P>By definition they are not the same at all regardless of what software you use to do them.</P> Tue, 03 Aug 2021 06:39:43 GMT https://communities.sas.com/t5/SAS-Programming/Are-full-join-and-cross-join-cartesian-product-same-thing-in-SAS/m-p/758969#M239738 SASKiwi 2021-08-03T06:39:43Z