Write your name in your program using a common statement. Use infile statement to read the data set. Assign a title with the problem number for each problem, Your output for each problem should contain only what is asked. Please submit your programs and outputs. Given Data/Code: From Separate Document Employee_id Name gender years dept salary01 salary02 salary03; 1 Mitchell, Jane A f 6 shoe 22,450 23,000 26,600 2 Miller, Frances T f 8 appliance . 32,500 33,000 3 Evans, Richard A m 9 appliance 42,900 43,900 . 4 Fair, Suzanne K f 3 clothing 29,700 32,900 34,500 5 Meyers, Thomas D m 5 appliance 33,700 34,400 37,000 6 Rogers, Steven F m 3 shoe 27,000 27,800 . 7 Anderson, Frank F m 5 clothing 33,000 35,100 36,000 10 Baxter, David T m 2 shoe 23,900 . 31,300 11 Wood, Brenda L f 3 clothing 33,000 34,000 35,700 12 Wheeler, Vickie M f 7 appliance 31,500 33,200 35,600 13 Hancock, Sharon T f 1 clothing 21,000 . 22,500 14 Looney, Roger M m 10 appliance 42,900 36,200 37,800 15 Fry, Marie E f 6 clothing 29,700 30,500 31,200 Problems: Apply both proc freq and proc chart to show the distribution of years of employment. . Apply both proc freq and proc chart to show the number of employees in each department for each gender. Calculate the average of the two highest salaries for employees who have three salaries and average of two salaries if they have only two salaries. Print the names of employees who have the highest average in their department. Also, print their averages, their department names, and the department averages. Obtain a table that shows the average of salary01 for each gender in each department. For each department, use a two-way table to show both the number of employees whose salar01 is above 30,000 and also the number of employees whose salarie01 is not above 30,000. Print the name of employee whose salary01 is the highest among all employees. For each department find the employee whose salary01 is the highest in the department. Print the names of these employees and department names. I think I have the correct code but I don't understand the infile statement to pull data from another source
... View more