@Ronein wrote: Both are done via proc sql( inner join and Cartesian product. As I understand you say that Cartesian product is more efficient( using where )?
No. What is more efficient is best determined by testing (see Maxim 4).
It is just that our database coders prefer to use the cartesian + WHERE, for whatever reason.