My dear friend @thisisneeraj, Nobody want big copmplicated program to execute small thing. At the end, everyone is looking for final output. Your program is much compliacted (As per understandiing) to execute this very small logic. As you raised the question, "How would you find department wise third highest salary ? " Here you go.!!!! data abc; input name $ dept $ sal comma6. loc $; cards; abc HR 32,392 CH ghs MAR 26,378 MY gsi HR 62,362 JU gdi HR 23,379 JK qim HR 83,368 UK own HR 82,738 IK KUW MAR 82,768 OK ; proc sort data=abc out=xyz; by dept descending sal; run; proc print data=xyz (firstobs=3 obs=3); var name dept sal loc; where dept= 'HR'; run; All the best!!!!
... View more