DATA Step, Macro, Functions and more

how to select only same values from 2 datasets

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

how to select only same values from 2 datasets

Hello,

 

I have a problem that looks easy but i don't find a solution:

 

I have 2 datasets with variables like this:

 

Data1: A B var1 var2 var3

Data2: A B var4 var5 var6

 

Variables A and B have values that exist in both datasets but also values that exist in only one or another table. B is  sub-classe of A.

 

I would like to keep only values that exist in both tables and delete the others.

 

I tried with merge and sql but couldn't find a solution. If anyone can help.

 

Thank you very much.

 

 


Accepted Solutions
Solution
‎03-31-2016 12:02 PM
Contributor
Posts: 38

Re: how to select only same values from 2 datasets

Have you tried something like this:

 

data want;
merge 
    have1 (in=x)
    have2 (in=y);
by a b;
if x and y;
run;

View solution in original post


All Replies
Solution
‎03-31-2016 12:02 PM
Contributor
Posts: 38

Re: how to select only same values from 2 datasets

Have you tried something like this:

 

data want;
merge 
    have1 (in=x)
    have2 (in=y);
by a b;
if x and y;
run;
Occasional Contributor
Posts: 7

Re: how to select only same values from 2 datasets

Yes! Thank you very much Smiley Happy
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 184 views
  • 0 likes
  • 2 in conversation