topic How to keep data from two matching variables in SAS Programming

How to keep data from two matching variables

sdevenny — Tue, 26 Apr 2022 19:43:42 GMT

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?

Re: How to keep data from two matching variables

Reeza — Tue, 26 Apr 2022 19:50:52 GMT

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?

Re: How to keep data from two matching variables

Kurt_Bremser — Wed, 27 Apr 2022 04:40:42 GMT

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;