Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedUse 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sybase Database Administrators Handbook

Authors: Brian Hitchcock

1st Edition

0133574776, 978-0133574777

More Books

Students also viewed these Databases questions

Question

Distinguish between filtering and interpreting. (Objective 2)

Answered: 1 week ago