How Data Step Merge and PROC SQL handle many-to-many relationship?
Data Step MERGE does not create a cartesian product incase of a many-to-many relationship. Whereas, Proc SQL produces a cartesian product.
SAS : Many-to-Many Merge
