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
- 38014 Views
- ABC, Amex, I also Faced
- E-Mail Answers
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 |
do you prefer proc report or proc tabulate? Why? : Sas programming
What are the advantages of using sas?
proc means? proc sort? proc append? proc freq? proc print? proc content?
Mention what is the difference between nodupkey and nodup options?
Given an unsorted data set, how to read the last observation to a new data set?
What is the use of PROC gplot?
how can you put a "trace" in your program? : Sas programming
What is the pound sign used for in the data_null_ ?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
what is the formula to measure Baseline
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
why is the use of Retrive statement and give me with example?
Teradata 
