Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Provide SAS sql code for this problem. Create a report that displays Employee_ID, Job_Title, Salary, and Salary Range for every manager Salary ange should have

image text in transcribed

Provide SAS sql code for this problem.

Create a report that displays Employee_ID, Job_Title, Salary, and Salary Range for every manager Salary ange should have a value of "Low" if the employee's salary is below S50,000, '"Medium" if it is between $50,000 and $80,000, and "High" if it is above S80,000 Hint: For full credit, use the scan function to narrow down the list to managers only iz^.putput of PROC SQL: Employee IDEm ployee Job Title Employee Annual Salary $108,255High 120102Sales Manager 120103Sales Manager 120104Administration Manager 120114Security Manager 120271Concession Manager 120660Logistics Manager $87,975High $46,230Low $31,285Low $43,635Low $61,125Medium

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

Databases In Networked Information Systems 6th International Workshop Dnis 2010 Aizu Wakamatsu Japan March 2010 Proceedings Lncs 5999

Authors: Shinji Kikuchi ,Shelly Sachdeva ,Subhash Bhalla

2010th Edition

3642120377, 978-3642120374

More Books

Students also viewed these Databases questions

Question

b. Why were these values considered important?

Answered: 1 week ago