(25pts) A local company has recently updated human resources information on their employees from a paper-based system into an actual database where the data can be manipulated and reviewed more efficiently.

1. Write the appropriate SAS code for a raw data file salaries.xlsx and read it into SAS. Modify the SAS data table so that the date of birth is a readable date and the salaries are displayed with a dollar sign and 2 decimal places when viewed or printed.
2. Suppose that the company conducts their annual review in December. Write an appropriate SAS code to calculate the age of each employee as of the last day of the current year, and report it in years as a whole number.
3. For each employee, write the appropriate SAS code to calculate the expected annual salary for the next year assuming that they receive a 2.8% pay raise. The result should be rounded to two decimal places.
4. Write an appropriate SAS code that creates a bonusvariable of $1,500.00 for employees who are leads, managers, or directors, and $100 otherwise.
5. Write an appropriate SAS code that creates a variable FLast, concatenating the first letter of the first name and the last name separated by a space. For example, "J Smith". Note the upper case of the first letter.