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
what do the pad and dim functions do? : Sas programming
How to limit decimal places for variable using proc means?
how does sas handle missing values in formats? : Sas programming
Mention what are the data types does SAS contain?
Explain proc univariate?
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
Give some ways by which you can define the variables to produce the summary report (using proc report)?
how would you create multiple observations from a single observation? : Sas programming
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
Of all your work, where have you been the most successful?
What do you code to create a macro? : sas-macro
Define run-group processing?
What are SAS/ACCESS and SAS/CONNECT?
Mention common programming errors committed in sas ?