Basically, I have 3 given variables and then 3 calculated variables. I want to find the means of GPA at each level of GPALevel. So I want my program to look at GPALevel and when GPALevel=1 I want it to calculate the mean of all the GPA's that are at GPALevel1. And when GPALevel=2 I want to calculate the mean of all the GPA's that have GPALevel=2. I can't figure out how to do this, whatever I try just outputs the mean of ALL the GPA's regardless of what their GPALevel is. Here is my code: data SATGPA;
input MathSAT $ VerbalSAT GPA;
SAT=MathSAT + VerbalSAT;
IF SAT<=1100 THEN SATLevel=1;
IF SAT>1100 and SAT<=1200 THEN SATLevel=2;
IF SAT>1200 and SAT<=1300 THEN SATLevel=3;
IF SAT>1300 THEN SATLevel=4;
IF GPA<=2.8 THEN GPALevel=1;
IF GPA>2.8 and GPA<=3.2 THEN GPALevel=2;
IF GPA>3.2 and GPA<=3.5 THEN GPALevel=3;
IF GPA>3.5 THEN GPALevel=4;
datalines;
580 420 2.9
670 530 2.83
680 540 2.9
630 640 3.3
620 630 3.61
580 550 2.75
620 600 2.75
690 500 3
520 500 2.77
570 630 2.9
620 550 3
690 570 3.25
350 300 3.13
680 570 3.53
550 530 3.1
570 540 3.2
620 640 3.27
750 560 3.3
700 680 2.6
670 550 3.53
680 550 2.67
590 700 3.3
600 650 3.5
630 640 3.7
;
... View more