1. Importing a Comma-Delimited Text File into a New SAS Data Set The employee_payroll.cav file is a comma -delimited text file . The first row in the text file contains appropriate names for the columns in the new SAS data set . The first eight rows of the text file are shown below. a. Create MYSAS. employee_payroll from the data in the "Import Data ! X @ Program ! N D Program 2 x employee_payroll .cav file. CODE LOG RESULTS OUTPUT DATA b. Do not include e the columns for Marital_Status or Dependents data MYSAS. employee_payroll; 2 set MYSAS.employee_payroll; 3 Format Salary Dollarie.2; C. Change the type for Employee_ID to Number Format Employee_ID Numeric; 5 DROP Marital Status; d. Change the format for Salary to Currency. DROP Dependents; CODE LOG RESULTS OUTPUT DATA Tables MYSAS EMPLOYEE PAYROLL - View Columnnames - Columns * Rows mploye_ID Employee_ Gender Salary Birth Date Employee_Hir 120186 F 126,795.00 19APR1979 01DECOS B & Employee Gande 121114 F 876515 09 DINOVISM CIDECDS 0 Salary 120187 F $26,865.00 10DEC1984 CIDECOS 121118 M 625.725 09 01MAR1979 SIDECOS 121121 F 135,735 00 0SMARTTM CIDECDS 121108 F Employes. Term_Date 120184 M 135.820.00 DIDECISIP CIDECDS 121111 M 826,885 00 17JULI44 61DECOS 121115 M 126,430.09 13FEB1939 CIDECOS 120181 F $27,065.00 28NOV1985 CIDECDS 120189 M 125.180.09 ORAALISM SIDECOS Mopen 121116 F Label 121122 M 526,265.00 01MAR1986 CIDECOS Name 121123 M Longer 121047 F 525,820.00 26NOV1979 OTSEPOS 121048 F 826.569:09 24JUNTOBE BISEPOS 121119 M $25.205.00 QINOV1984 CIDECDS 121120F $35 035 03 HOCLISTS CIDECOS 2. Creating a Data Set with Only the Active Employees by Modifying the Generated SAS Program Subset the employee_payroll_b data set to include only current employees who do not have a termination date a. Select Tasks [ Data _ Filter Data. Select employee_payroll_b