How to keep data from two matching variables

[sdevenny]

Hello,

My data looks something like this:

var1    var2

 1          2

 3          3

 1          3

I need to keep only the data points that match, such as when var1 and var2 both have a value of 3, and I can get rid of the rest of the data. How could I do this? 

[Reeza · Accepted solution]

data want;
set have;
if var1=var2;
run;

---

@sdevenny wrote:

Hello,

My data looks something like this:

var1    var2

 1          2

 3          3

 1          3

I need to keep only the data points that match, such as when var1 and var2 both have a value of 3, and I can get rid of the rest of the data. How could I do this? 

---

[Kurt_Bremser]

Since all values for the condition are contained in the incoming dataset, you can use WHERE in its different forms as statement, dataset option or SQL clause:

data want;
set have;
where var1 = var2;
run;

data want;
set have (where=(var1 = var2));
run;

proc sql;
create table want as
  select * 
  from have
  where var1 = var2
;
quit;