Question: (30 pts) SAS PROC SQL can be very flexible and powerful when creating data tables and variables. However, SAS data steps can be more convenient

(30 pts)SAS PROC SQL can be very flexible and powerful when creating data tables and variables. However, SAS data steps can be more convenient in some cases, especially when creating multiple variables using conditional logics. We will reuse the salaries.xlsxdata file. After reading it in, use PROC SQL for the following tasks.

  1. Write SAS code that will add a 'bonus' variable of $1,000.00 for employees whose job title (existing variable name is "job title" (NOTE: the variable name does include the space between "job" and "title") contains the words 'lead', 'manager', or 'director', and all other job titles will receive $200.

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