BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
smantha
Lapis Lazuli | Level 10

In here you are not merging the datasets but concatenating one to the bottom of the other. What about the overlapping records?

_MVB_
Obsidian | Level 7

@smantha yes, I should have used a concatenating, not merging.

Overlapping records are not an issue, there is a purpose of why these 1,000 records from dataset2 needed on the final dataset. They would be exactly same, because they were outputted in earlier steps from the dataset1. I just need a final dataset to have 11,000 records with an indicator which would be used later to differentiate whether it is coming from dataset1 or dataset 2. 

Patrick
Opal | Level 21

@_MVB_ wrote:

@smantha yes, I should have used a concatenating, not merging.

Overlapping records are not an issue, there is a purpose of why these 1,000 records from dataset2 needed on the final dataset. They would be exactly same, because they were outputted in earlier steps from the dataset1. I just need a final dataset to have 11,000 records with an indicator which would be used later to differentiate whether it is coming from dataset1 or dataset 2. 


Then look again at what @Reeza already proposed because that's doing what you're asking for.

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
  • 17 replies
  • 7058 views
  • 6 likes
  • 5 in conversation