Question: 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

 Provide SAS sql code for this problem. Create a report that

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!