topic Re: Proc SAS SQL - RB in SAS Programming

Proc SAS SQL - RB

rb688 — Fri, 15 Mar 2019 10:16:41 GMT

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.

Re: Proc SAS SQL - RB

RW9 — Fri, 15 Mar 2019 10:52:01 GMT

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&q=get+top+5+results

E.g.

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

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

Re: Proc SAS SQL - RB

rb688 — Fri, 15 Mar 2019 11:48:13 GMT

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

Re: Proc SAS SQL - RB

RW9 — Fri, 15 Mar 2019 12:26:20 GMT

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-by-rank/m-p/125463#M21491

Here shows another version:

https://communities.sas.com/t5/SAS-Programming/Need-to-Filter-Top-10-records-from-multiple-groups-after/m-p/529497/highlight/true#M144686

Another showing proc rank:

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

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-data-AKA-generate/ta-p/258712

And show what you would like out from that.