Question: 6 Please compete both in SAS using PROC SQL statement; Using the EXCEPT Operator to Count Rows Create a report that displays the total count
6 Please compete both in SAS using PROC SQL statement;


Using the EXCEPT Operator to Count Rows Create a report that displays the total count of employees who did not make any charitable donations. The orion.Employee_organization table contains a record for every employee in the Orion Star organization and includes the employee identification numbers. The orion. Employee_donations table contains records only for employees who made charitable donations, including the Employee_ID value. PROC SQL Output No. Employees w No Charitable Donations 300 Using the INTERSECT Operator to Count Rows Create a report that shows the total number of customers who placed orders. The orion.Order fact table contains information about the orders that were placed by Orion Star customers, including Customer_ID. The orion. Customer table contains information on all Orion Star customers, including Customer iD. PROC SQL Output No. Customers wI Orders 75 Using the EXCEPT Operator to Count Rows Create a report that displays the total count of employees who did not make any charitable donations. The orion.Employee_organization table contains a record for every employee in the Orion Star organization and includes the employee identification numbers. The orion. Employee_donations table contains records only for employees who made charitable donations, including the Employee_ID value. PROC SQL Output No. Employees w No Charitable Donations 300 Using the INTERSECT Operator to Count Rows Create a report that shows the total number of customers who placed orders. The orion.Order fact table contains information about the orders that were placed by Orion Star customers, including Customer_ID. The orion. Customer table contains information on all Orion Star customers, including Customer iD. PROC SQL Output No. Customers wI Orders 75
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
