Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started