topic Re: delete duplicate based on value of a second variable in SAS Programming

delete duplicate based on value of a second variable

Kelli — Fri, 07 Mar 2014 16:43:20 GMT

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?

Re: delete duplicate based on value of a second variable

Peter_C — Fri, 07 Mar 2014 17:24:33 GMT

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 ;

Re: delete duplicate based on value of a second variable

sas121987 — Fri, 07 Mar 2014 17:36:51 GMT

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