file ‘employee.csv’ is a comma delimited text file that contains information about the employees of a small firm.

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Question:

The file ‘employee.csv’ is a comma delimited text file that contains information about the employees of a small firm. The file contains an employee id, employee gender, salary, birth date, employee hire date, employee term date, marital status, number of dependents, and promotion status. The variables salary, birth date, employee hire date, and employee term date are formatted appropriately in the text file as money or dates.

1. Format the variables salary, birth date, hire date, and termination date so they appear as expected given the types of data. (Look up format statements or how to format a variable in SAS. It should be a simple line of the code that says format, the variable name, and the format.). (5 points).
2. Use an appropriate summary to report the average raise. Only active employees should be included in the analysis. Place the report below. (5 pts).
3. Create a visualization (i.e. histogram) of the salary after all of the raises for the active employees. Place the report below. (5 pts).
4. Count up and report the number of individuals who did and did not get a promotion. Place the report below. (5 pts).
5. Create a pie graph that displays the proportion with and without promotion. Place the graphic below. (5 pts).

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme