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.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 1273 views
  • 2 likes
  • 4 in conversation