how to get second highest salary from a employee table and
how get a 5th highest salary from a employee table?
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
How can you create a macro variable with in data step? : sas-macro
How can I remove header from output data set?
How can you limit the variables written to output dataset in data step?
Mention few capabilities of sas framework.
for whom is sas data integration studio designed? : Sas-di
what is sas metadata repository? : Sas-bi
If a variable contains only numbers, can it be a character data type?
What is connection profile? : sas-grid-administration
Which are the statements whose placement in the data step is critical?
Can you suggest us materials for sdtm mapping?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
What are the applications primarily used by business analyst? : Sas-bi
Give e an example of..
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
explain the difference between proc means and proc summary?