The SAS-table variable Coulor can take the values Red, Blue, Green, Yellow, Black, White or Brown.
Each month I want to run some SAS code that find the numbers of the three most frequent colours. They should be presented in alphabetical order. The numbers of the four other colours should be added under the name Others and placed on the last line.
The output should look like this(the colours and their numbers should be presented in 2 columns):