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

combine  two  datasets using multiple SET statement and   with MERGE statement.

 

can any one give the example and explannation 

 

1 ACCEPTED SOLUTION

Accepted Solutions
ballardw
Super User

Be more specific about what you want to know. Multiple set statements work in a variety of ways depending on how they are used.

 

And Merge behaves somewhat differently in one-to-one, one-to-many or many-to-many  with By variables or without.

View solution in original post

3 REPLIES 3
Kurt_Bremser
Super User

I already told you three weeks ago that using "base sas" as the subject in the "Base SAS Programming" forum is stupid. Are you allergic to learning?

 

set will put the two datasets in sequence, merge will put them side-by-side.

ballardw
Super User

Be more specific about what you want to know. Multiple set statements work in a variety of ways depending on how they are used.

 

And Merge behaves somewhat differently in one-to-one, one-to-many or many-to-many  with By variables or without.

andreas_lds
Jade | Level 19

SAS provides a detailled product documentation, there you will an explanation of almost every aspect of the sas programming language.

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