I am having trouble figuring out how to use select here. I want to use the select statement to make a new variable called 'FGrade', but I am not sure what I can do or what I cannot do with a select statement. It keeps giving me multiple errors, but I am not sure how to fix it. I would appreciate any help. Here is my code so far: data school;
input Age Quiz : $1. Midterm Final;
if Age eq 12 then Grade = 6;
else if Age eq 13 then Grade = 8;
if Quiz eq 'A' then QuizGrade=95;
else if Quiz eq 'B' then QuizGrade=85;
else if Quiz eq 'C' then QuizGrade=75;
else if Quiz eq 'D' then QuizGrade=70;
else if Quiz eq 'F' then QuizGrade=65;
CourseGrade = (0.2*QuizGrade)+(0.3*Midterm)+(0.5*Final);
*Part c. - Using SELECT statements;
select;
when (CourseGrade ge 97) FGrade = 'A+';
when (CourseGrade ge 93 and le 97) FGrade = 'A';
when (CourseGrade ge 90 and le 93) FGrade = 'A-';
when (CourseGrade ge 87 and le 90) FGrade = 'B+';
when (CourseGrade ge 83 and le 87) FGrade = 'B';
when (CourseGrade ge 80 and le 83) FGrade = 'B';
when (CourseGrade ge 77 and le 80) FGrade = 'C+';
when (CourseGrade ge 73 and le 77) FGrade = 'C';
when (CourseGrade ge 70 and le 73) FGrade = 'C-';
when (CourseGrade ge 67 and le 70) FGrade = 'D+';
when (CourseGrade ge 63 and le 67) FGrade = 'D';
when (CourseGrade ge 60 and le 63) FGrade = 'D-';
when (CourseGrade lt 60) FGrade = 'F';
otherwise;
end;
12 A 92 95
12 B 88 88
13 C 78 75
13 A 92 93
12 F 55 50
13 B 88 82
;
... View more
