Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 program

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2019 Wurzburg Germany September 16 20 2019 Proceedings Part 2 Lnai 11907

Authors: Ulf Brefeld ,Elisa Fromont ,Andreas Hotho ,Arno Knobbe ,Marloes Maathuis ,Celine Robardet

1st Edition

3030461467, 978-3030461461

More Books

Students also viewed these Databases questions