Interested to Buy Any Domain ? << Click Here >> for more details...
how to get second highest salary from a employee table and
how get a 5th highest salary from a employee table?
- 11 Answers
- 37494 Views
- ABC, Amex, I also Faced
- E-Mail Answers
Answer Posted / vidit malhotra
/*Proc RANK method*/
proc rank data=paydept out=order descending ties=dense;
var Salary;
ranks SalaryRank;
run;
proc sql;
select Name,Salary,SalaryRank from order where SalaryRank IN (2,5);
quit;
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
do you need to know if there are any missing values? : Sas programming
In ARRAY processing, what does the DIM function do?
What can be the size of largest dataset in SAS?
What are SAS/ACCESS and SAS/CONNECT?
which date function advances a date, time or datetime value by a given interval? : Sas programming
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
why is sas considered self-documenting? : Sas programming
explain about various caches available in data integrator? : Sas-di
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What are the features of SAS?
Tell e how how dealt with..
Briefly explain input and put function?
What is the work of tranwrd function?
