BookmarkSubscribeRSS Feed
niladri_routray
Calcite | Level 5

Hello,

 

I need help. Can you please tell me using merge statement how to fetch records common to both the datasets.

2 REPLIES 2
silvergrenade
Obsidian | Level 7
Hi,
Use the following snippet.

data final.;
merge first_data(in=a) second_data(in=b);
by common_variable1 common_variable2 ;
if a and b ;
mi_ind=compress(a||b);
run;

Take a freq of mi_ind. It should only have 11

Cheers
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Please use the search functionality of the forum, or look down the posts over the last day.  There have been at least five examples of this exact question!

 

Also, if you want to recieve a good answer then follow the guidance which is just below the post button = post example test data in the form of a datastep which illustrates your problem, example of what you want the output to look like, and any other logic, code you may have already have etc.  Otherwise we are just guessing.

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
  • 2 replies
  • 1253 views
  • 1 like
  • 3 in conversation