Write SQL

The Orion.Employee_paryroll table is

5,0 Using SAS Functions Create a report that includes each employee's age at time of employment. a. report should contain the columns Employee ID, Birth Date, Employee Hire Date, and Age. b. obtain the data for the report from the orion.employee payroll table. c. Calculate Age as int ((Employee Hire Date-Birth Date) /365.25). d. Add this title to the report: Age at Employment. e. Display Birth Date and Employee Hire Date values using the MMDDYY 10. format. f Label each column as shown in the following sample report Partial PROC SQL Output Age at Employment Employee ID Birth Date Hire Date Age 120101 08/18/1980 07/01/2007 26 120102 08/11/1973 06/01/1993