Question: Use SAS to solve the question Question 1 (20 points) Name Gender BirthDate Salary Department. Married Rick M 10/11/1997 120,000 Information Technology Y Dan M
Use SAS to solve the question
Question 1 (20 points) Name Gender BirthDate Salary Department. Married Rick M 10/11/1997 120,000 Information Technology Y Dan M 02/19/1993 150, 400 Information Technology N Mike F 07/21/1996 112,500 Operation Y Ryan F 09/15/1999 95,000 Operation N Gary M 12/21/1994 102,000 Operation N Tusar F 04/16/1991 135,020 Information Technology Y 1. Write a SAS DATA step to read the data above. The list of variables is Name, Gender, BirthDate, Salary, Department and Married. Select the data on condition that Birthdate is before than 1996 Aug 1st with an IF statement and print out the data set table after selection with title 'Company Data'. (Do not change the input format of data) 2. Write a SAS PROC step to print out the observations on condition that the Salary greater than 115,000 and Gender is 'M' in the whole dataset without IF selection. Also change the format for Birthdate (e.g. 110CT97, 19FEB93). 3. Create a new variable "SalaryLevel". Assign SalaryLevel = 'A' when Salary>=130,000, SalaryLevel when 110,000=
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
