topic Re: remove duplicate values based on two numerical values in SAS Programming

remove duplicate values based on two numerical values

ari — Fri, 08 Jul 2016 15:38:03 GMT

I want keep only one observation where a=5 and b=1

please let me know how to do this in sas.

Thanks in advance.

ballardw — Fri, 08 Jul 2016 14:39:17 GMT

Probably the easiest if the file is not extremely large is

Proc sort data=have out=want noduprecs;

by id;

run;

ari — Fri, 08 Jul 2016 14:56:39 GMT

I have updated the dataset, what if several variables like var3 exist in the dataset?

ballardw — Fri, 08 Jul 2016 15:14:19 GMT

You may need to post a more complete example if your data is more complex.

1 2 3 4 5

1 2 3 6 6 <only var3 duplicates does this get deleted?>

1 2 3 4 6 <only var3 and var4 duplicate the first, does this get deleted?>

1 2 3 4 5 <all of var3, var 4 and var5 duplicate the first, the original proc sort solution would work>

ari — Fri, 08 Jul 2016 16:03:46 GMT

Answer: the follwing code gives what i want.

Proc sort data= data out= want;

by id a b e;

run;

Thanks forum.