how to get second highest salary from a employee table and
how get a 5th highest salary from a employee table?
Answers were Sorted based on User's Feedback
Answer / richa
It can be done by first sorting the dataset in the
ascending order of salary and then using the 'point='
option.
For eg:
proc sort data = x;
by salary;
quit;
/*second highest salary*/
data y;
a = 2;
set x point = a;
stop;
run;
/*fifth highest salary*/
data y;
a = 5;
set x point = a;
stop;
run;
| Is This Answer Correct ? | 1 Yes | 9 No |
sas implimented companies in hyderabad
PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?
What report output formats can you generate using SAS?
how do you test for missing values? : Sas programming
How we can call macros with in data step? : sas-macro
how to perform paired t-test using Base/SAS & SAS/Stat?
Which are SAS Windows Clients & SAS Java Clients
Explain the special input delimiters used in sas programming.
What is the order of application for output data set options, input data set options and SAS statements?
in which companies SAS openings are there? List of companies using SAS technology.
What is connection profile? : sas-grid-administration
What are the data types does SAS contain?