https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629939#M186427 <P>have you tried proc summary?</P> Thu, 05 Mar 2020 20:15:52 GMT ChrisNZ 2020-03-05T20:15:52Z https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629595#M186215 Wed, 04 Mar 2020 20:17:48 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629595#M186215 Saikiran_Mamidi 2020-03-04T20:17:48Z https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629605#M186223 <P>You can use proc summary's <FONT face="courier new,courier">idgroup</FONT> option.</P> <P>Many resources online like&nbsp;<A href="http://support.sas.com/resources/papers/proceedings10/026-2010.pdf" target="_self">here</A> or <A href="https://documentation.sas.com/?docsetId=proc&amp;docsetTarget=n0afy7c5m16m9dn1s60z9krjmwxq.htm&amp;docsetVersion=9.4&amp;locale=en" target="_self">here</A>.</P> Wed, 04 Mar 2020 21:00:09 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629605#M186223 ChrisNZ 2020-03-04T21:00:09Z https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629607#M186224 <P>PROC RANK</P> Wed, 04 Mar 2020 21:16:17 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629607#M186224 PaigeMiller 2020-03-04T21:16:17Z https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629754#M186318 <P>other than proc rank</P> Thu, 05 Mar 2020 10:05:25 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629754#M186318 Saikiran_Mamidi 2020-03-05T10:05:25Z https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629772#M186328 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/304446">@Saikiran_Mamidi</a>&nbsp;wrote:<BR /> <P>other than proc rank</P> <HR /></BLOCKQUOTE> <P>It's the perfect solution</P> Thu, 05 Mar 2020 11:52:49 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629772#M186328 PaigeMiller 2020-03-05T11:52:49Z https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629775#M186331 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/304446">@Saikiran_Mamidi</a>&nbsp;wrote:<BR /> <P>other than proc rank</P> <HR /></BLOCKQUOTE> <P>Why? Is this just a stupid interview question or are there any objective reasons to avoid the perfect tool?</P> Thu, 05 Mar 2020 12:29:07 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629775#M186331 andreas_lds 2020-03-05T12:29:07Z https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629939#M186427 <P>have you tried proc summary?</P> Thu, 05 Mar 2020 20:15:52 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/629939#M186427 ChrisNZ 2020-03-05T20:15:52Z https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/630169#M186514 <PRE><CODE class=" language-sas">proc sql; select * from emp group by dept having sal=max(sal) ; quit;</CODE></PRE> Fri, 06 Mar 2020 17:34:44 GMT https://communities.sas.com/t5/SAS-Programming/How-to-select-top-3-salaries-from-each-dept-wise/m-p/630169#M186514 BrahmanandaRao 2020-03-06T17:34:44Z