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!!

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
Get step-by-step solutions from verified subject matter experts
