Why the "All Other" option is missing from rank? How can I eliminate the All Other from report. The variable Month number is just treats the months to numbers and is working.
Thanks
hi, the reason the 'All other' bar is shown, is because 'Options -> Data options -> Combine excluded...' is checked. This causes the bar to combine any data values to be aggregated into this bar for any item which is excluded (due to ranking). You can uncheck this option - if you don't want to see this bar. Not too sure whether that answers your question - but let us know if you need more details. Regards, Falko
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.