https://communities.sas.com/t5/SAS-Programming/Find-the-TOP-X-and-the-Bottom-X/m-p/416914#M102393 <P>Also, use option<STRONG> NEXTROBS=n</STRONG> in proc univariate to display the n highest and n lowest observations.</P> Tue, 28 Nov 2017 23:39:00 GMT PGStats 2017-11-28T23:39:00Z https://communities.sas.com/t5/SAS-Programming/Find-the-TOP-X-and-the-Bottom-X/m-p/416909#M102391 <P>Hello,</P><P>&nbsp; &nbsp;I have one column in a dataset with 5M Rows of data. I'm trying to understand the range of values and figure out the general distribution.&nbsp;&nbsp;How would I select a percentage of the highest amounts and a percentage of the lowest amounts?&nbsp;Thanks!&nbsp;</P> Tue, 28 Nov 2017 23:08:39 GMT https://communities.sas.com/t5/SAS-Programming/Find-the-TOP-X-and-the-Bottom-X/m-p/416909#M102391 JayCompany 2017-11-28T23:08:39Z https://communities.sas.com/t5/SAS-Programming/Find-the-TOP-X-and-the-Bottom-X/m-p/416910#M102392 <P>I would recommend a histogram first - using PROC UNIVARIATE.&nbsp;</P> <P>It also displays the highest.&nbsp;</P> <P>&nbsp;</P> <P>Then I would also recommend PROC RANK.&nbsp;</P> <P>Rank the variable of interest using groups of 100, then you can find all less than X% by choosing all less than the Xth rank. Note how it handles tied values though - and that's one reason I prefer this methodology. It can account for ties where some of the manual methodologies will not, by default, so you need extra coding.</P> Tue, 28 Nov 2017 23:09:38 GMT https://communities.sas.com/t5/SAS-Programming/Find-the-TOP-X-and-the-Bottom-X/m-p/416910#M102392 Reeza 2017-11-28T23:09:38Z https://communities.sas.com/t5/SAS-Programming/Find-the-TOP-X-and-the-Bottom-X/m-p/416914#M102393 <P>Also, use option<STRONG> NEXTROBS=n</STRONG> in proc univariate to display the n highest and n lowest observations.</P> Tue, 28 Nov 2017 23:39:00 GMT https://communities.sas.com/t5/SAS-Programming/Find-the-TOP-X-and-the-Bottom-X/m-p/416914#M102393 PGStats 2017-11-28T23:39:00Z