BookmarkSubscribeRSS Feed
deleted_user
Not applicable
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?
2 REPLIES 2
Bill
Quartz | Level 8
If you have SAS/QC, then proc pareto will do this for you.
deleted_user
Not applicable
I don't have SAS/QC.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 615 views
  • 0 likes
  • 2 in conversation