Hi Everyone,
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.
Kindly suggest me a solution.
Regards,
Harsh Patel.
Hi Harsh,
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..
Regards
Sandy
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.