Question: Complete using PROC SQL statement in SAS; 6. Using a Correlated Subquery Generate a report that displays Employee_ID, Employee Gender, and Marital_Status for all employees
Complete using PROC SQL statement in SAS;

6. Using a Correlated Subquery Generate a report that displays Employee_ID, Employee Gender, and Marital_Status for all employees who donate more than 0.02 of their salary. The table orion.Employee donations contains Employee ID, quarterly donations (Qtrl-Qtr and charities (Recipients). The orion.Employee Payroll table contains Employee and Salary information Partial PROC SQL Output Employees with Donations > 8.82 Of Their Salary Employee Marital Status Employee_ID Gender 128267F 128688F 128686F 128689 F 128753 M
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
