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
- 38360 Views
- ABC, Amex, I also Faced
- E-Mail Answers
Answer Posted / poorna m
proc sort data=emp out=emp1 nodupkey;
by descending sal empid;
run;
PROC RANK DATA=emp1 OUT=emp3 TIES=LOW DESCENDING;
VAR sal ;
RANKS highestsal;
RUN;
data emp4;
set emp3;
where highestsal in (2,5);
run;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
explain the proc in sas? : Sas-administrator
What is the function of output statement in a SAS Program?
What are symget and symput? : sas-macro
How does proc sql work?
Describe the ways in which you can create a macro variable?
Give some examples where proc report’s defaults are different than proc print’s defaults?
Explain the use of proc print and proc contents?
What are the special input delimiters used in SAS?
State the difference between INFORMAT and FORMAT ?
What are the differences between proc means and proc summary?
How many data types are there in SAS?
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
What is your favorite all time computer book? Why?
What is the difference between INPUT and INFILE ?
Define run-group processing?
