how to get second highest salary from a employee table and
how get a 5th highest salary from a employee table?
Answer Posted / na
Proc sql;
Select salary
From
Where salary in (select max
(salary) from
Where salary <(select max
(salary) from
));
Quit;
For second salary
calculation
If salary is not repeted
then
Proc sort data= xxx;
By salary;
Run;
Options firstobs =5;
Proc print data = xxx;
Var salary;
Run;
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What commands are used in the case of including or excluding any specific variables in the data set?
explain the function of substr in sas? : Sas-administrator
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
Explain the difference between nodup and nodupkey options?
Mention common programming errors committed in sas ?
What is the difference between %local and %global? : sas-macro
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
In SAS explain which statement does not perform automatic conversions in comparisons?
what is sas application server? : Sas-di
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
What are the statements that are executed only?
what is information maps?
Explain the purpose of retain statement.
Mention what is SAS data set?
How substr function works in sas?