Question: (5%) Create a library named HW4 that points to the same location you store any SAS files for this assignment. (40% @ 5% each) The

(5%) Create a library named "HW4" that points to the same location you store any SAS files for this assignment. (40% @ 5% each) The following plain text files need to be combined into a single data set - to start the process you need to read each one of them into their own SAS data sets. AO Division.dat (2 variables, 10 records) CORP Division.dat (2 variables, 2 records) EmpData.dat (4 variables, 500 records) FINANCE IT Division.dat (2 variables, 7 records) FLIGHT OPS Division.dat (2 variables, 9 records) HR. Division.dat (2 variables, 10 records) Personal.dat (4 variables, 500 records) - SALES Division.dat (2 variables, 4 records) (10%) Create a single data set in SAS using the Division files and name it DIVISION. (5%) Complete the combination of the data sets by using the now-combined division data and joining it with EmpData and Personal to create the complete data set and name it Air Emps Full. (5%) Ensure the Air Emps Full data set does not include the PHONE variable and update the salary variable to be named CurrentSalary. Apply the DOLLAR format to the salary variable with sufficient width to ensure all records are properly represented. (10%) Use the Air Emps Full data set to create a subset of data that only includes records for employees that were hired prior to 1990 and whose current salary is below $45,000. Name this data set Air Emps Underpaid. Hint: There is an easy way and a hard way to do this. To do it the easy way, I suggest you use a date literal such as '060CT2016'd in your program. (Date literals are not case sensitive.) (5%) Ensure both data sets include labels for all variables that match mine. (5%) Print out the validated data set of underpaid employees to a PDF document named "Underpaid Employees' located in the same folder as your library for this assignment. You should ensure that this report is never printed to any destination other than the PDF
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
