DATA Step, Macro, Functions and more

delete duplicate based on value of a second variable

Reply
New Contributor
Posts: 2

delete duplicate based on value of a second variable

I have a dataset where I want to delete duplicate entries for the same person.  I have an employee ID field and then two values A and B for a second variable.  In any case where there is a duplicate employee ID, I want to delete the entry that has a value of B for the second variable.  Is there a simple way to code for this?

Valued Guide
Posts: 2,175

Re: delete duplicate based on value of a second variable

assuming your data are sorted by empID, how about

data REDUCED ;

set yourdata( where=( secondvar NE 'B' ))

      yourdata( where=( secondvar EQ 'B' )) ;

by empID ;

if first.empID ;

run ;

Occasional Contributor
Posts: 6

Re: delete duplicate based on value of a second variable

Hello you can do this in using nodupkey in data step using first.

please find the code logic:

proc sort data = test ;

by employeeID Column2;

run;

data test2;

set  test;

by employeeID ;

if first.column2 then output;

run;

Here you will get the unique first values of column2

Thanks

Ask a Question
Discussion stats
  • 2 replies
  • 203 views
  • 0 likes
  • 3 in conversation