04-03-2018 06:21 PM
04-03-2018 06:38 PM
04-03-2018 09:56 PM - edited 04-04-2018 07:09 PM
04-03-2018 09:36 PM
best way to understand by making up data and try out various scenarios. This will tremendously increase your knowledge. check with on clause initially then try where clauses. Nothing better than learning by doing.
04-04-2018 02:17 AM
And while you're doing your tests, as @kiranv_ suggested, also try a solution with sort and data steps, where you do the joins piecemeal.
With larger datasets, the overall performance might surprise you.
Caveat: This is only possible with 1-to-many, not with many-to-many relationships, where SQL is needed for the cartesian join.