How to select top 3 salaries from each dept wise?

[ChrisNZ]

You can use proc summary's idgroup option.

Many resources online like here or here.

[PaigeMiller]

PROC RANK

[Saikiran_Mamidi]

other than proc rank

[PaigeMiller]

---

@Saikiran_Mamidi wrote:

other than proc rank

---

It's the perfect solution

[andreas_lds]

---

@Saikiran_Mamidi wrote:

other than proc rank

---

Why? Is this just a stupid interview question or are there any objective reasons to avoid the perfect tool?

[ChrisNZ]

have you tried proc summary?

[BrahmanandaRao]

proc sql;
select *
from emp
group by dept
having sal=max(sal)
;
quit;