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

/*sort employee table by salary in desending order */

proc sort data=xx nodupkey;
by descending sal ;
run;
/*outputting the second and 5th largest salary to then yy
dataset */
data yy;
set xx;
if _n_ in (2, 5) then output;
run;

Is This Answer Correct ?    35 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the functions which are used for character handling functions?

1078


Explain append procedure?

1022


Differences between where and if statement?

1024


What is the difference between nodupkey and nodup options?

971


how are numeric and character missing values represented internally? : Sas programming

1087


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

1118


what is treatment emergent events and treatment emregent adverse event

2325


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2025


What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1723


what are _numeric_ and _character_ and what do they do? : Sas programming

1102


Explain translate function?

1128


what is the effect of the options statement errors=1? : Sas programming

1000


What is a pdv and what are its functions?

1045


i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2315


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1415