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.
- 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
Get step-by-step solutions from verified subject matter experts
