Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Print the name of employee whose salary01 is the highest among all employees. For each department find the employee whose salary01 is the highest in

  1. Print the name of employee whose salary01 is the highest among all employees.
  2. For each department find the employee whose salary01 is the highest in the department. Print the names of these employees and department names.

here is the data

data mt; input Employee_id Name$ gender$ years dept$ salary01 salary02 salary03; cards; 1 Mitchell,Jane f 6 shoe 22450 23000 26600 2 Miller,Frances f 8 appliance . 32500 33000 3 Evans,Richard m 9 appliance 42900 43900 . 4 Fair,Suzanne f 3 clothing 29700 32900 34500 5 Meyers,Thomas m 5 appliance 33700 34400 37000 6 Rogers,Steven m 3 shoe 27000 27800 . 7 Anderson,Frank m 5 clothing 33000 35100 36000 10 Baxter,David m 2 shoe 23900 . 31300 11 Wood,Brenda f 3 clothing 33000 34000 35700 12 Wheeler,Vickie f 7 appliance 31500 33200 35600 13 Hancock,Sharon f 1 clothing 21000 . 22500 14 Looney,Roger m 10 appliance 42900 36200 37800 15 Fry,Marie f 6 clothing 29700 30500 31200 ; run;

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mathematical Interest Theory

Authors: Leslie Jane, James Daniel, Federer Vaaler

3rd Edition

147046568X, 978-1470465681

More Books

Students also viewed these Mathematics questions

Question

hello, how do you prepare an information memorandum.... kindly help

Answered: 1 week ago