BookmarkSubscribeRSS Feed
SR_FR
Obsidian | Level 7

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

1 REPLY 1
LinusH
Tourmaline | Level 20

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.

Data never sleeps

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1549 views
  • 0 likes
  • 2 in conversation