Using proc_sql

3. Creating a Table and Inserting Data Using a Complex Query Create a table named direct_compensation in the work library. The table should contain the following information for all non-managerial Sales staff (those with a level listed in their titles), formatted as indicated: - Sales information is available in orion.order_fact. - The table orion.sales contains Employee_ID, First_Name, Last_Name,_Job_Title, and Salary information for all Sales staff. - Job_Title contains level information for each employee. Copyright @2015, SAS Institute Inc., Cary, North Carolina, USA. ALL RIGHTS RESERVED. 2 Module 3 - Lesson 2 SOL Creating Tables and Views - To calculate Commission, add the Total_Retail_Price values for all sales made by an employee with an order date in 2011 , and take 15% of that total value as commission. - To calculate Direct_Compensation, add Commission plus Salary. Partial PROC SQL Output