Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please complete in SAS and provide a copy of codes as well as ouput 2. Using Multiple SASFILE Statements a. Open the program p302e02 and
Please complete in SAS and provide a copy of codes as well as ouput
2. Using Multiple SASFILE Statements a. Open the program p302e02 and submit it. p302e02 options fullstimer; proc means data orion.employee_donations sum mean median; class Recipients; var Qtrl-Qtr4; run: proc freq data orion.employee donations; run proc report data orion.employee addresses headline headskip nowd; tables Recipients; columns EmployeeID Employee Name City State; define State/width-5; where Country'US run: proc freq data orion.employee addresses; run proc sql; tables CountrY; select Employee Name, sum (9trl, Qtr2, 2tr3, Qtr4) as Total_Contribution, Recipients from orion.employee_addresses as a, orion.employee donations as d where a.Employee ID-d.Employee_ID; quit; options nofullstimer; 2-4 Chapter 2 g I/O Processing and Memory b. Add the appropriate statement(s) to open and load both the orion.employee addresses and orion.employee donations data sets into memory. At the end of the program, close the data sets. c. Submit the revised program. 2. Using Multiple SASFILE Statements a. Open the program p302e02 and submit it. p302e02 options fullstimer; proc means data orion.employee_donations sum mean median; class Recipients; var Qtrl-Qtr4; run: proc freq data orion.employee donations; run proc report data orion.employee addresses headline headskip nowd; tables Recipients; columns EmployeeID Employee Name City State; define State/width-5; where Country'US run: proc freq data orion.employee addresses; run proc sql; tables CountrY; select Employee Name, sum (9trl, Qtr2, 2tr3, Qtr4) as Total_Contribution, Recipients from orion.employee_addresses as a, orion.employee donations as d where a.Employee ID-d.Employee_ID; quit; options nofullstimer; 2-4 Chapter 2 g I/O Processing and Memory b. Add the appropriate statement(s) to open and load both the orion.employee addresses and orion.employee donations data sets into memory. At the end of the program, close the data sets. c. Submit the revised programStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started