PROC SQL and MANY to MANY merges

SR_FR — Thu, 02 Jan 2014 11:13:25 GMT

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

Re: PROC SQL and MANY to MANY merges

LinusH — Thu, 02 Jan 2014 12:24:11 GMT

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.

topic PROC SQL and MANY to MANY merges in SAS Programming

PROC SQL and MANY to MANY merges

Re: PROC SQL and MANY to MANY merges