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
- 38370 Views
- ABC, Amex, I also Faced
- E-Mail Answers
Answer Posted / pricil kurian
/*sort employee table by salary in desending order */
proc sort data=xx nodupkey;
by descending sal ;
run;
/*outputting the second and 5th largest salary to then yy
dataset */
data yy;
set xx;
if _n_ in (2, 5) then output;
run;
| Is This Answer Correct ? | 35 Yes | 13 No |
Post New Answer View All Answers
how do you pull data from equifax?tell me the process?
Do you need to rearrange the order of the data for the report?
Explain data_null_?
List down the reasons for choosing sas over other data analytics tools.
what is sas data set?
what is change analysis in sas di ? : Sas-di
How do dates work in SAS data?
Can you explain the process of calendar?
What are the statements in proc sql?
Enlist the functions performed by sas.
What is data _null_?
How substr function works in sas?
What is the work of tranwrd function?
What’s the difference between var b1 – b3 and var b1 — b3?
Explain the difference between using drop = data set option in set and data statement?
