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

Question

The Orion.employee_payroll is 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 orion.employee payroll table. c. Calculate Age as int loyee 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 MMDDYY10. 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

Explanation / Answer

title "Age at Employment";

PROC SQL;
select
Employee_ID label="Employee ID",
Birth_Date format mmddyy10. label="Birth Date",
Employee_Hire_Date format mmddyy10. label="Hire Date",
(Employee_Hire_Date-Birth_Date)/365.25 as Age format 2.
from orion.employee_payroll;
QUIT;

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

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