Question: SAS Base Programming: Need Help with Homework Question PLS!! The Santa Barbara Times keeps information about their employees in a file called Employees.txt, located at

SAS Base Programming: Need Help with Homework Question PLS!!

SAS Base Programming: Need Help with Homework Question PLS!! The Santa Barbara

The Santa Barbara Times keeps information about their employees in a file called Employees.txt, located at '/home/user/personnel'. This file contains the following variables (in the specified columns): ID Last First Birth Division Articles Degree StartDate MonthlySalary 3-10 15- 32- 50-59 62-63 68-71 74 76-83 85-92 Char 30 45 Char Char Num Num Char Num CharChange. i.e. 1-4 i.e. i.e. 12345.67 07/14/1990 07/21/19 Assume work. Employees contains all the variables seen in Employees.txt. In this data set, only the variables ID, Last, First, and Division are character variables. In a single step, create two formats: 1) Display the values of degree as follows: 1 = 'High School', 2 = College', 3 = 'Masters', 4 = 'Advanced Degree'. 2) Display the values of division as follows: 'SP' = 'Sports', 'BU' = Business', 'ET' = 'Entertainment', and everything else as 'News'. Use work. Employees to create a report with labels, but no observation numbers (column). In this report, only show employees who whose last name begin with an 'M' and are in the Business division. Apply the (above) user-defined formats to degree and division, and display the total number of observations at the end of the report

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!