topic Re: How to use 'Select' Statement to make a new variable in New SAS User

How to use 'Select' Statement to make a new variable

Abby1 — Sun, 21 Feb 2021 17:00:55 GMT

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
;

Re: How to use 'Select' Statement to make a new variable

PaigeMiller — Sun, 21 Feb 2021 18:12:27 GMT

Your code needs a cards; statement after the end; and before the data.

Your syntax is wrong in select, it should be (here is one example, you can change the rest of them):

when (CourseGrade ge 93 and CourseGrade le 97) FGrade = 'A';

Also, your select statements will assign a 93 to A-, even though you appear to have it in the A category, because your conditions in the select statement overlap, and you probably want to fix that.

For your future benefit, when you get errors in the log, SHOW US THE LOG. Show us the entire log of the step where the errors are, in the sequence it appears in the log, with nothing chopped out.

Re: How to use 'Select' Statement to make a new variable

Kurt_Bremser — Sun, 21 Feb 2021 18:14:28 GMT

You have no DATALINES statement.