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


Please Help Members By Posting Answers For Below Questions

How can you create a macro variable with in data step? : sas-macro

984


How can I remove header from output data set?

2573


How can you limit the variables written to output dataset in data step?

1247


Mention few capabilities of sas framework.

1126


for whom is sas data integration studio designed? : Sas-di

946


what is sas metadata repository? : Sas-bi

1052


If a variable contains only numbers, can it be a character data type?

1033


What is connection profile? : sas-grid-administration

1109


Which are the statements whose placement in the data step is critical?

1188


Can you suggest us materials for sdtm mapping?

4387


what is PhaseIII, ODS, TLG, Macro and Proc in SAS

4423


What are the applications primarily used by business analyst? : Sas-bi

941


Give e an example of..

2036


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3529


explain the difference between proc means and proc summary?

1071