Find records with identical variable values.

[deleted_user]

Table variables NR and X. I want to keep the records for each NR, where the values of X are identical.

From

NR X
10 1
10 2
10 2
10 3
10 4
10 4
10 4
10 5
.

I would like to get

NR X
10 2
10 2
10 4
10 4
10 4
.

How can that be done in a data step?

[LinusH]

You could use SET with BY nr, then using first. and last. logic in a subsetting IF statement.

/Linus

[deleted_user]

You mean BY X, I suppose?

IF FIRST.X=0 OR LAST.X=0;

[LinusH]

Yes, I was a bit quick.
It should be

BY nr x;

/Linus

[CurtisMack]

Here is how I would handle this (I do it all the time for data validation purposes)
--------------------------------------------
data test;
input NR X;
cards;
10 1
10 2
10 2
10 3
10 4
10 4
10 4
10 5
;
run;

proc sort data=test;
by NR X;
run;

data dups;
set test;
by NR X;
if not(first.X and last.X);
run; Message was edited by: Curtis Mack