Description

• Create a library named “HW5” that points to the same location you store any SAS files for this assignment.
• Create a library named “HW4” that points to the Air Emps Full and Air Emps Underpaid data sets.
• Using the Air Emps Full data set from your previous assignment you need to create a new data set named Air Emps Raises that contains a new salary variable named New Salary that is computed as follows. (Note the percentage increase should not be affected by the flat increase.)
– For employees with at least 35 years of service, the new salary includes:
∗ A $3,500 flat increase
∗ A 2.5% increase for anyone whose job is at level 2 or level 3 (e.g. FLTAT3)
∗ A 1.5% raise for anyone whose job is at level 1 (e.g. MECH01)
∗ A 2.0% raise for all other jobs
– For employees with at least 25 years of service (but not 35 or more), the new salary includes:
∗ A $2,000 flat increase
∗ A 2.0% increase for level 2 or 3 jobs
∗ A 1.0% increase for level 1 jobs ∗ A 1.75% increase for all other jobs – For all others, the new salary includes:
∗ No flat increase
∗ A 2.50% increase for level 2 or 3 jobs
∗ A 1.25% increase for level 1 jobs
∗ A 0.75% increase for all other jobs
– If years of service cannot be computed for an employee
∗ New Salary should be missing
∗ A note should be printed to the log, indicating the employee ID that needs to be investigated
• Ensure that in addition to the new salary variable you created the employee’s old salary is available and named Old Salary.
• Ensure the final data set is sorted by EMPID and that your two new variables (New Salary and Years of Service) have appropriate labels and formats.
• Without recreating the Air Emps Underpaid data set we want to subset it to only include individuals whose new salary would still classify them as underpaid. To do this, create the New Salary variable in this data set as well but only keep records that would still be classified as underpaid even after they got a raise!
• Write both data sets to a single PDF using titles and footnotes to differentiate the two data sets. Additionally, create a separate PDF that contains only the Employee’s ID, Years of Service, and New Salary.