I want bottom rank based on conditional parameter in SAS VA 7.3 for instance suppose if i will enter value more than 500 than the list table should reflect the value greater than parameter and apart from that i want bottom 5 ranks based on that parameter only.So if there are 10 rows which would reflect data but i need bottom 5 only based on above parameter hence not considering rows below 500.
You place a filter on the conditional parameter by selecting value greater than 500. And then go to Ranks tab, create a rank on that parameter with Bottom 5 condition so that you will get the desired values which you are looking into..
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.