delete duplicate based on value of a second variable

[Kelli]

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?

[Peter_C]

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 ;

[sas121987]

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