how to get second highest salary from a employee table and
how get a 5th highest salary from a employee table?
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
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
What are the functions used for character handling?
Of all your work, where have you been the most successful?
What are the prime responsibilities of data integration administrator? : Sas-di
what is the difference between floor and ceil functions in sas? : Sas-administrator
What do you know about sas and what we do? : sas-grid-administration
What is the length assigned to the target variable by the scan function?
for report generation which one you used proc report or data_null_?
what is data integration? : Sas-di
What is SAS? What are the functions does it performs?
What is the difference between where and if statement?
How would you determine the number of missing or nonmissing values in computations?
how do you pull data from equifax?tell me the process?
: and & modifiers.
how will you locate the sas platform applications? : Sas-bi