Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In sas, what are the areas that you are most interested in? : sas-grid-administration

1130


what is hash files in sas and why we are using this one in sas?

2268


What is the difference between using drop = data set option in data statement and set statement?

1209


What is the difference between nodupkey and nodup options?

1081


What do the SAS log messages "numeric values have been converted to character" mean?

1431


I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com

2773


what is program data vector? : Sas-administrator

1126


what is sas and what are the functions? : Sas-administrator

1032


What does the trace option do?

1163


What do you know about sas and what we do? : sas-grid-administration

1234


explain what is data set in sas? : Sas-administrator

1036


What is data _null_?

1196


If a variable contains letters or special characters, can it be numeric data type?

1282


What are the ways in which macro variables can be created in sas programming?

1175


Explain what is the use of proc gplot?

1247