topic Remove entry that is duplicated in one variable but not others in New SAS User

Remove entry that is duplicated in one variable but not others

sasprogramming — Tue, 03 Dec 2019 23:48:14 GMT

Below is a snippet from very large data set. The problem I am experiencing is to do with duplicates. As you can see below I have duplicated values in the 'ID' column, however the rest of the values in the other coloumns are not duplicates. What I want to do is:

Remove the row with the 'first' duplicate, where there a zero entry in Var1 and blanks in Var2 and Var 3.
Therefore keeping the row where there is information for all variables.

How can I achieve this is SAS?

Thanks

Re: Remove entry that is duplicated in one variable but not others

ballardw — Wed, 04 Dec 2019 00:00:13 GMT

One way:

proc sort data=have;
   by id Var1;
run;

data want;
   set have;
   by id;
   if first.id and var1=0 and missing(var2) and missing(var3) then delete;
run;

Re: Remove entry that is duplicated in one variable but not others

sasprogramming — Wed, 04 Dec 2019 02:32:52 GMT

That worked, thank you!