topic Re: Help on calculations in SAS Studio

Help on calculations

jeaster0 — Fri, 10 Feb 2017 19:42:48 GMT

Create new variable called Adjusted GPA that is the GPA reported in the fileminus the average GPA for everyone.

This is what I have so far:

PROC Summary Data=Students;
   Var GPA;
   Output out=Students1(Keep=AveGPA) mean=AveGPA;
Run;
Data studentnew;
   if_n_=1 then set Students;
   set students1;
   AdjGPA=(sum"GPA"n)/AveGPA;
   AdjGPA= round(AdjGPA, .01);
run;

Re: Help on calculations

art297 — Fri, 10 Feb 2017 19:59:15 GMT

Your description and code don't match. In one you say GPA-avgGPA, but in the other you divide the two.

Regardless, I think the following will work (although you might have to change the calculation if you are looking for the remainder):

PROC Summary Data=sashelp.class (rename=(age=gpa));
    Var gpa;
    Output out=Students1(Keep=AveGPA) mean=AveGPA;
Run;

Data studentnew;
    set sashelp.class (rename=(age=gpa));
    if _n_=1 then set students1;
    AdjGPA=round(GPA/AveGPA, .01);
run;

HTH,

Art, CEO, AnalystFinder.com

Re: Help on calculations

Reeza — Fri, 10 Feb 2017 20:20:13 GMT

1. Calculate average and store in dataset

2. Merge with main dataset

3. Subtract

SQL solution, one step.

proc sql;
create table want as 
select *, 
mean(gpa) as avg_gpa,  /*1*/
gpa - calculated avg_gpa as GPA_Residual /*3*/
from students; /*2*/
quit;

Data step/proc solution. Note the datasets names are reversed from yours, and I set Validvarname = V7 so no need for name literals.

options validvarname=v7;
/*1*/
PROC Summary Data=Students;
    Var GPA;
    Output out=Students1(Keep=AveGPA) mean=AveGPA;
Run;

Data studentnew;
/*2*/
    if_n_=1 then set Students1;
    set students;

    AdjGPA =round( GPA-AveGPA, 0.01); /*3*/

run;