topic Re: Delete duplicate rows if two variables are not identical in SAS Programming

Delete duplicate rows if two variables are not identical

BenBrady — Tue, 20 Jun 2017 06:19:31 GMT

I want to keep only the duplicates where there is an identical match betwwen sport1 and sport2. So in the following table I only want to keep Person A where sport1 and Sport2 are both soccer and Person D where Sport1 and Sport2 are both Tennis

Person	Sport1	Sport2
A	Soccer	Soccer
A	Soccer	Table Tennis
A	Soccer	Rugby
B	Footy	Footy
C	Baseball	Baseball
D	Tennis	Badmington
D	Tennis	Tennis

Re: Delete duplicate rows if two variables are not identical

Kurt_Bremser — Tue, 20 Jun 2017 06:36:51 GMT

data want;
set have;
if sport1 = sport2;
run;

This is called a subsetting if.

You can do it in a where condition, if you want only one entry per person:

proc sort
  data=have (
    where=(sport1 = sport2)
  )
  out=want (keep=person)
  nodupkey
;
by person;
run;

Re: Delete duplicate rows if two variables are not identical

Ksharp — Tue, 20 Jun 2017 12:40:03 GMT

To be honest. I don't understand your question.

data have;
input (Person Sport1 Sport2) ($);
cards;
A Soccer Soccer 
A Soccer Table Tennis 
A Soccer Rugby 
B Footy Footy 
C Baseball Baseball 
D Tennis Badmington 
D Tennis Tennis 
;
run;
proc sql;
select *
 from have
  group by person
   having sum(sport1=sport2) ne count(*) and  sum(sport1=sport2) ne 0;
quit;