Please let me know how to get largest top 5 name of States and smallest bottom States as comparing to India in above or attached data.
Please use the search bar at the top of the page before posting questions which have been answered many times previously:
https://communities.sas.com/t5/forums/searchpage/tab/message?advanced=false&allow_punctuation=false&...
E.g.
your reply not matched with the query. Pls understand the question??
Your question has been asked many times, you may need to do some alteration based on your specific data, however the question is no different. Here for instance shows you a sort+datastep example.
Here shows another version:
Another showing proc rank:
If you would like actual code, please present test data in the form of a datastep:
And show what you would like out from that.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.