Description

• Create a library named “HW4” that points to the same location you store any SAS files for this assignment.
• The following plain text files need to be combined into a single data set
– AO Division.dat
– CORP Division.dat
– EmpData.dat
– FINANCE IT Division.dat
– FLIGHT OPS Division.dat
– HR Division.dat
– Personal.dat
– SALES Division.dat
• Create a single data set in SAS using the Division files and name it DIVISION.
• Use the now-combined division data and combine it with EmpData and Personal to create the complete data set and name it Air Emps Full.
• Ensure the Air Emps Full data set does not include the PHONE variable and update the salary variable to be named CurrentSalary. Include an appropriate format for this variable.
• 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.
• Ensure both data sets include appropriate labels for all variables.