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
- 38012 Views
- ABC, Amex, I also Faced
- E-Mail Answers
Answer Posted / pallavi
proc sort data=xxx;
by descending sal;
run;
proc sql;
select Sal, monotonic() as count
from xxx
having count in(2,5);
quit;
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
Mention sas system options to debug sas macros.
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
What are the data types that sas contain?
How can sas program be validated?
What are the ways in which macro variables can be created in sas programming?
What are common programming errors committed in sas
for whom is sas data integration studio designed? : Sas-di
explain the key concept of sas? : Sas-administrator
Explain the use of proc print and proc contents?
is data integration and etl programming is same? : Sas-di
What is your favorite all time computer book? Why?
What is the difference between proportion and average?
Explain what is SAS informats?
where are dashboard components are created and maintained? : Sas-bi
What is the difference between one to one merge and match merge? Give an example.
