topic Re: Find records with identical variable values. in SAS Programming

Find records with identical variable values.

deleted_user — Mon, 19 Oct 2009 08:09:28 GMT

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?

Re: Find records with identical variable values.

LinusH — Mon, 19 Oct 2009 08:15:18 GMT

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

/Linus

Re: Find records with identical variable values.

deleted_user — Mon, 19 Oct 2009 08:33:24 GMT

You mean BY X, I suppose?

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

Re: Find records with identical variable values.

LinusH — Mon, 19 Oct 2009 09:52:01 GMT

Yes, I was a bit quick.
It should be

BY nr x;

/Linus

Re: Find records with identical variable values.

CurtisMack — Tue, 20 Oct 2009 14:43:54 GMT

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