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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

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