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?
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 ;
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
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.