how to get second highest salary from a employee table and
how get a 5th highest salary from a employee table?
Answer Posted / pallavi
proc sort data=xxx;
by descending sal;
run;
proc sql;
select Sal, monotonic() as count
from xxx
having count in(2,5);
quit;
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
what is null hypothesis? why do you consider that?
how sas deals with business intelligence? : Sas-bi
what are validation tools that are used in sas? : Sas-administrator
In SAS explain which statement does not perform automatic conversions in comparisons?
how to generate the test data in sas without input data? : Sas-administrator
what is operational data and operational system? : Sas-di
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
How can I remove header from output data set?
List down the reasons for choosing sas over other data analytics tools.
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
Are you involved in writing the inferential analysis plan? Tables specfications?
This entry was posted in General. Bookmark the permalink. Post a comment or leave
What are the advantages of using sas?
How to include or exclude specific variables in a data set?
Difference between sum function and using “+” operator?