topic Re: Filtering data by two variables in New SAS User

Filtering data by two variables

Viktoreli — Wed, 27 Nov 2019 10:01:42 GMT

Hi!

I have somewhat of a problem that I could not find a solution for.

I want to filter out datalines where variable A is not unique for any different variable B and C combination so that only one dataline remain.

A B C

1 2 3 5

2 2 3 5

3 2 4 5

4 2 5 4

5 3 1 2

6 3 2 1

7 3 1 2

A B C

1 2 3 5

2 2 4 5

3 2 5 4

4 3 1 2

5 3 2 1

I would much apreciate any help!

Re: Filtering data by two variables

sustagens — Wed, 27 Nov 2019 10:05:27 GMT

data have;
  input A:8. B:8. C:8.;
datalines;
2 3 5
2 3 5
2 4 5
2 5 4
3 1 2
3 2 1
3 1 2
;
run;

proc sort data=have nodupkey out=want;
by a b c;
run;

Re: Filtering data by two variables

ed_sas_member — Wed, 27 Nov 2019 10:05:34 GMT

Hi @Viktoreli ,

You can try this::

data have;
	input A B C;
	cards;
2 3 5
2 3 5
2 4 5
2 5 4
3 1 2
3 2 1
3 1 2
;
run;

proc sort data=have;
	by A B C;
run;

data want;
	set have;
	by A B C;
	if first.C then output;
run;

Re: Filtering data by two variables

Kurt_Bremser — Wed, 27 Nov 2019 10:05:45 GMT

The simplest way:

proc sort
  data=have
  out=want
  nodupkey
;
by a b c;
run;

Re: Filtering data by two variables

Kurt_Bremser — Wed, 27 Nov 2019 10:07:05 GMT

And the SQL version:

proc sql;
create table want as
select distinct *
from have;
quit;