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;

Complete using PROC SQL statement in SAS; 6. Using a Correlated Subquery

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

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!