Present frequencies in a data set, in a certain order.

[deleted_user]

I have a SAS data set, DataSet1, with among others, a character variable City, that can take 15 different values(city names). I want to find the 5 most frequent cities. The 10 remaining should be counted under the name "Others".

I want the frequencies presented in a new SAS data set, DataSet2, with the two variables City and Number. Number should be in descending order, but 'Others' should always be placed last, like this:

Paris 45
Barcelona 41
Rome 38
Berlin 31
London 28
Others 42

How can that be coded?

[Bill]

If you have SAS/QC, then proc pareto will do this for you.

[deleted_user]

I don't have SAS/QC.