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

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 1535 views
  • 0 likes
  • 2 in conversation