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
Mention what is PROC in SAS?
For what purpose would you use the RETAIN statement?
Give an example where SAS fails to convert character value to numeric value automatically?
Which statement does not perform automatic conversions in comparisons?
Explain why double trailing @@ is used in input statement?
explain the function of substr in sas? : Sas-administrator
What do the put and input function do?
What is proc sort?
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
what is metadata? : Sas-bi
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
What is the length assigned to the target variable by the scan function?
how to change the execute of macro
How do you control the number of observations and/or variables read or written?