topic Condition on duplicate values in a dataset in SAS Procedures

Condition on duplicate values in a dataset

jayanty — Fri, 01 Mar 2013 16:53:44 GMT

Hi,

I have a dataset that looks like below.

Column-1 Rank

row1 A

row2 B

row3 C

row1 B

row2 A

I am trying to achieve a dataset where only unique values of Column-1 are listed with considering only the highest rank record where A>B>C in ranking.

Like this:

Column-1 Rank

row1 A

row2 A

row3 C

Any help is highly appreciated.

Re: Condition on duplicate values in a dataset

LinusH — Fri, 01 Mar 2013 17:08:21 GMT

select column_1, min(rank), as rank

from have

group by column_1

;

Re: Condition on duplicate values in a dataset

jayanty — Fri, 01 Mar 2013 17:23:52 GMT

Thank you LinusH. That works perfectly. I appreciate the quick response.