Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help me revise the following code in SAS, I need assistance adding the appropriate statements to load both the orion.employee_addresses and orion.employee_donations data set

Please help me revise the following code in SAS, I need assistance adding the appropriate statements to load both the orion.employee_addresses and orion.employee_donations data set into memory. Then at the end of the program close the datasets.

options fullstimer;

proc means data=orion.employee_donations sum mean median;

class Recipients;

var Qtr1-Qtr4;

run;

proc freq data=orion.employee_donations;

tables Recipients;

run;

proc report data=orion.employee_addresses headline headskip nowd;

columns Employee_ID Employee_Name City State;

define State/width=5;

where Country='US';

run;

proc freq data=orion.employee_addresses;

tables Country;

run;

proc sql;

select Employee_Name, sum(Qtr1, Qtr2, Qtr3, 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;

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

Step: 3

blur-text-image

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

Understanding Oracle APEX 5 Application Development

Authors: Edward Sciore

2nd Edition

1484209893, 9781484209899