You are asked to extract data from three input data files and create a new dataset with the columns and conditions given below. The specs for naming the various files to submit your homework are also given below. Please make sure to follow the specs as you will lose points for non-compliant submissions. You may work on this homework in pairs. If working in pairs, make sure to name the files to show both your login names.

Download Instructions: The data files for this homework are combined into a zip file named “HW1Data.zip” and posted on Canvas. First, please create a folder to download and store data files. Then, download the zipped file “HW1Data.zip” from Canvas, extract the following data files (i.e., original data) and copy them to your newly created folder.

employee_payroll.csv

employee_info.xlsx

employee_organization.sas7bdat

Then, create the final dataset with the following Columns (the column sequence should be maintained as below):

Employee_ID

Employee_Name

Employee_Gender

City

Marital_Status

Dependents

Job_Title

Employee_Hire_Date

Department

Salary

TakeHomePay (To be computed as specified below)

Target (To be computed as specified below)

Computed column details:

TakeHomePay = Salary – Deductions withheld @ 15% of Salary

Target = "US" for all records in this dataset

The output data should satisfy the following conditions:

1. The employees should be from the US.
2. The employees should have been hired in 1990 or later.
3. The employees should be married and with at least 2 dependents.
4. The employees should be from one of the following departments:

a. Sales

b. Marketing

c. IS

d. Logistics Management

Can someone please help me understand the problem step by step?