Question: Write SQL SAS code The Orion.employee_payroll 5. Using SAS Functions Create a report that includes each employee's age at time of employment. a. The report
5. Using SAS Functions Create a report that includes each employee's age at time of employment. a. The report should contain the columns Employee LD, Birth Date, Employee Hire Date, and Age. b. obtain the data for the report from the onion,employee payroll table c. Calculate Age as int lot Hire Date -Birth Date) /365.25) d. Add this title to the report: Age at Employment. e. Display Birth Date and Employee Hire ate values using the MMIDDYY10. format. f. Label each column as shown in the following sample report Partial PROC SQLOutput 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
