Question: Write SAS code (SQL) Challenge 7. Subsetting Data Using the ESCAPE Clause Create a report that displays the Employee ID and Recipients for all employees

Write SAS code (SQL)  Write SAS code (SQL) Challenge 7. Subsetting Data Using the ESCAPE
Clause Create a report that displays the Employee ID and Recipients for

Challenge 7. Subsetting Data Using the ESCAPE Clause Create a report that displays the Employee ID and Recipients for all employees who contributed 90% of their charitable contributions to a single company that was incorporated Inc.) and is the last recipient in the list to receive the 90% contribution. Use the orion.employee donations table. Hint: Use the ESCAPE clause in the WHERE clause to solve this problem. Alternative methods can be used to solve this problem, but for this exercise, use the LlKE operator with an ESCAPE clause. PROC SQL Output Employee ID Recipients 120783 Disaster Assist, Inc. 10s, Cancer Cures, Inc. 901 121012 Child Survivors 10s, Disaster Assist, Inc. 90A 121 136 Disaster Assist, Inc. 10%, Cancer Cures Inc. 904

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!