Proc SAS SQL - RB

[rb688]

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. 

[RW9]

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.

https://communities.sas.com/t5/SAS-Procedures/How-to-get-a-summary-for-the-top-5-10-and-other-data/m...

https://communities.sas.com/t5/SAS-Programming/Output-Top-5-Reasons-for-Survey-Answer/m-p/303837/hig...

[rb688]

your reply not matched with the query. Pls understand the question??

[RW9]

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.

https://communities.sas.com/t5/General-SAS-Programming/how-to-select-top-100-observation-a-variable-...

Here shows another version:

https://communities.sas.com/t5/SAS-Programming/Need-to-Filter-Top-10-records-from-multiple-groups-af...

Another showing proc rank:

https://communities.sas.com/t5/SAS-Programming/Top-5-by-observations-per-each-county/m-p/423333/high...

If you would like actual code, please present test data in the form of a datastep:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

And show what you would like out from that.