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
- 37503 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
what is the one statement to set the criteria of data that can be coded in any step? : Sas programming
Mention how to limit decimal places for the variable using proc means?
what is sas and what are the functions? : Sas-administrator
What does proc print, and proc contents are used for?
what does the run statement do? : Sas programming
Describe 5 ways to do a “table lookup” in SAS?
What makes sas stand out to be the best over other data analytics tools?
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
Give some ways by which you can define the variables to produce the summary report (using proc report)?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
Explain translate function?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
How many data types are there in SAS?
Differentiate between ceil and floor functions.
Are you involved in writing the inferential analysis plan? Tables specfications?
