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 GenderUse 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==130,000, SalaryLevel when 110,000=

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