Help using Base SAS procedures

Condition on duplicate values in a dataset

Reply
New Contributor
Posts: 2

Condition on duplicate values in a dataset

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.

Super User
Posts: 5,255

Re: Condition on duplicate values in a dataset

select column_1, min(rank), as rank

from have

group by column_1

;

Data never sleeps
New Contributor
Posts: 2

Re: Condition on duplicate values in a dataset

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

Ask a Question
Discussion stats
  • 2 replies
  • 133 views
  • 1 like
  • 2 in conversation