Challenge 7. Subsetting Data Using the ESCAPE Clause Create a report that displa
ID: 3801884 • Letter: C
Question
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. 904Explanation / Answer
The SAS code is as follows:-
Proc sql;
select employee_id,recipients from from orion.employee_donation where recipients like ", Inc" escape ", ";
quit;