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

Write SQL SAS code
 Write SQL SAS code The Orion.employee_payroll 5. Using SAS Functions Create
The Orion.employee_payroll
a report that includes each employee's age at time of employment. a.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!