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 / na

Proc sql;
Select salary
From
Where salary in (select max
(salary) from
Where salary <(select max
(salary) from
));
Quit;
For second salary
calculation

If salary is not repeted
then
Proc sort data= xxx;
By salary;
Run;
Options firstobs =5;
Proc print data = xxx;
Var salary;
Run;

Is This Answer Correct ?    4 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to generate the test data in sas without input data? : Sas-administrator

1137


explain about various caches available in data integrator? : Sas-di

1051


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

1381


for what purpose would you use the retain statement? : Sas programming

1096


what do the mod and int function do? What do the pad and dim functions do? : Sas programming

1170


What do the put and input function do?

1062


what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

1007


explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

1074


Of all your work, where have you been the most successful?

4669


Describe crosslist option in tables statement?

1224


What is the difference between %local and %global? : sas-macro

1189


Which statement does not perform automatic conversions in comparisons?

1786


Where do you use proc means over proc freq?

1120


what versions of sas have you used (on which platforms)? : Sas programming

1071


If you could design your ideal job, what would it look like?

2931