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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.