topic Present frequencies in a data set, in a certain order. in SAS Programming https://communities.sas.com/t5/SAS-Programming/Present-frequencies-in-a-data-set-in-a-certain-order/m-p/22628#M3678 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".<BR /> <BR /> I want the frequencies presented in a <B>new SAS data set</B>, DataSet2, with the two variables City and Number. Number should be in descending order, but 'Others' should always be placed last, like this:<BR /> <BR /> Paris 45<BR /> Barcelona 41<BR /> Rome 38<BR /> Berlin 31<BR /> London 28<BR /> Others 42<BR /> <BR /> How can that be coded? Thu, 23 Apr 2009 12:59:04 GMT deleted_user 2009-04-23T12:59:04Z Present frequencies in a data set, in a certain order. https://communities.sas.com/t5/SAS-Programming/Present-frequencies-in-a-data-set-in-a-certain-order/m-p/22628#M3678 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".<BR /> <BR /> I want the frequencies presented in a <B>new SAS data set</B>, DataSet2, with the two variables City and Number. Number should be in descending order, but 'Others' should always be placed last, like this:<BR /> <BR /> Paris 45<BR /> Barcelona 41<BR /> Rome 38<BR /> Berlin 31<BR /> London 28<BR /> Others 42<BR /> <BR /> How can that be coded? Thu, 23 Apr 2009 12:59:04 GMT https://communities.sas.com/t5/SAS-Programming/Present-frequencies-in-a-data-set-in-a-certain-order/m-p/22628#M3678 deleted_user 2009-04-23T12:59:04Z Re: Present frequencies in a data set, in a certain order. https://communities.sas.com/t5/SAS-Programming/Present-frequencies-in-a-data-set-in-a-certain-order/m-p/22629#M3679 If you have SAS/QC, then proc pareto will do this for you. Thu, 23 Apr 2009 13:01:51 GMT https://communities.sas.com/t5/SAS-Programming/Present-frequencies-in-a-data-set-in-a-certain-order/m-p/22629#M3679 Bill 2009-04-23T13:01:51Z Re: Present frequencies in a data set, in a certain order. https://communities.sas.com/t5/SAS-Programming/Present-frequencies-in-a-data-set-in-a-certain-order/m-p/22630#M3680 I don't have SAS/QC. Thu, 23 Apr 2009 17:43:45 GMT https://communities.sas.com/t5/SAS-Programming/Present-frequencies-in-a-data-set-in-a-certain-order/m-p/22630#M3680 deleted_user 2009-04-23T17:43:45Z