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

Hello,

 

I have two data sets with three rows each and i want want to do one to one merge in Enterprise Guide using the GUI. How can i do that? In query builder such an option does nto exist. I do not want to use any code.

 

 

Thanks,

 

 

Andreas 

1 ACCEPTED SOLUTION

Accepted Solutions
TomKari
Onyx | Level 15

There really isn't any formal way, because SAS implements queries with SQL, which is dependent on keys for matching.

 

However, there is a rather iffy option. For each of your input tables, do a query, and create a new computed column / advance expression. In the expression, use

monotonic()

and name the column SeqNum or some such thing. This should put a sequential number into each row of the table. You can then do an inner join.

 

Note that the monotonic function isn't supported, to the best fo my knowledge. If you search the communities, you'll find a lot of discussion of it.

 

Tom

View solution in original post

3 REPLIES 3
TomKari
Onyx | Level 15

There really isn't any formal way, because SAS implements queries with SQL, which is dependent on keys for matching.

 

However, there is a rather iffy option. For each of your input tables, do a query, and create a new computed column / advance expression. In the expression, use

monotonic()

and name the column SeqNum or some such thing. This should put a sequential number into each row of the table. You can then do an inner join.

 

Note that the monotonic function isn't supported, to the best fo my knowledge. If you search the communities, you'll find a lot of discussion of it.

 

Tom

andreaszaras1
SAS Employee
Thanks a lot,

That worked!

Andreas
Reeza
Super User

Do you not have a field to join on? Otherwise in query builder add a new table and then the join condition becomes available. 

 

The add a table and join options are above the column where the variables are listed. 

 

 

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

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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
  • 3 replies
  • 2706 views
  • 2 likes
  • 3 in conversation