Answered step by step
Verified Expert Solution
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
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,125MediumStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started