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