You get the Cartesian product when you join two tables and do not subset them with a WHERE clause or ON clause. proc sql; title 'The Cartesian Product of'; title2 'LEFTTAB and RIGHTTAB'; select * from ...