PROC SQL and MANY to MANY merges

[SR_FR]

Hi

and a happy new year 😉

Duplicates values or improper fusion keys can lead you to perform many to many merges but PROC SQL is producing no particular message in the log to tell you that while a DATA/MERGE step is giving you the famous message :

NOTE: MERGE statement has more than one data set with repeats of BY values.

Let's take an example :

is there an option (or an automatic macro variable) that can tell me that I'm performing a many to many merge ?

(I didn't fin any...)

best regards

Sébastien

[LinusH]

Sorry, I can't find any option that will help you on this.

But it could be a nice feature though, so you could consider adding a ballot entry for this (you'll have my vote!).

Counting input and output records will in many cases (not all) hint you whether you join is doing what you want or not.