The Orion.employee_payroll 5. Using SAS Functions Create a report that includes

Question

The Orion.employee_payroll
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

Explanation / Answer

TITLE 'Age at Employment'; PROC SQL; SELECT Employee_ID as Employee ID, Birth_Date format = mmddyy10. as Birth Date Employee_Hire_Date format = mmddyy10. as Hire Date, (Employee_Hire_Date - Birth_Date)/365.25 as Age FROM orion.employee_payroll order by Employee_ID; QUIT;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.