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
- 37509 Views
- ABC, Amex, I also Faced
- E-Mail Answers
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 is the work of tranwrd function?
explain the concepts and capabilities of business object? : Sas-bi
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
Explain data_null_?
how can you import .csv file in to sas? : Sas programming
What is a method to debug and test your SAS program?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Have you used macros? For what purpose you have used? : sas-macro
What is slibref?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
What are the differences between proc means and proc summary?
Explain what is data step?
Which command is used to save logs in the external file?
Do you know the features of sas?
How to test the debugging in sas?
