Question: 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

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!