Complete using PROC SQL statement in SAS;

2. Using a Noncorrelated Subquery Each month a memo is posted that lists the employees who have employment anniversaries for that month. Create the report for February and list Employee ID and the first and last names for all employees hired during the month of February of any year You can find Employee _Name in the orion.Employee Addresses table and Employee Hire Date in the orion.Employee Payroll table. Both tables contain column Employee_ID. Order the report by an employee's last name a. Create a query that returns a list of employee IDs for employees with a Feb The query should do the following: Display Employee_ID numbers. . Use the orion.Employee Payroll table. . Return only employees whose Employee Hire_Date isin . Add a title to the report as shown. Employee IDs for February Ann Employee_ID 128187 8136 12 128167 128177 128194 128267 128658 128667 128671 128677 128715 2. Using a Noncorrelated Subquery Each month a memo is posted that lists the employees who have employment anniversaries for that month. Create the report for February and list Employee ID and the first and last names for all employees hired during the month of February of any year You can find Employee _Name in the orion.Employee Addresses table and Employee Hire Date in the orion.Employee Payroll table. Both tables contain column Employee_ID. Order the report by an employee's last name a. Create a query that returns a list of employee IDs for employees with a Feb The query should do the following: Display Employee_ID numbers. . Use the orion.Employee Payroll table. . Return only employees whose Employee Hire_Date isin . Add a title to the report as shown. Employee IDs for February Ann Employee_ID 128187 8136 12 128167 128177 128194 128267 128658 128667 128671 128677 128715