Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Write SQL SAS code
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 The Orion.employee_payroll
Step 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