topic How do I change a numeric grade to a letter grade? in SAS Programming

How do I change a numeric grade to a letter grade?

Mark7807 — Tue, 19 Nov 2013 23:53:49 GMT

How do I change a numeric grade to a letter grade?

There are 4 sets of data that needs to be given a letter ranking

Re: How do I change a numeric grade to a letter grade?

ballardw — Wed, 20 Nov 2013 00:09:49 GMT

Do you actually need to "change" or just generate an associated text value? A custom format would allow you to display a grade for the given numeric value. Assume the values are integers in the range 0 to 100 something like this:

Proc format;

value grade

91 - 100 = 'A'

81 - 90 = 'B'

71 - 80 = 'C'

61 - 70 = 'D'

low - 60 = 'F'

. = 'NA'

;

run;

Data test;

do grade = 1 to 100;

output;

end;

run;

/* to see a summary of the above data*/

proc freq data=test;

tables grade;

format grade grade.;

run;

Re: How do I change a numeric grade to a letter grade?

Mark7807 — Wed, 20 Nov 2013 00:40:06 GMT

I can generate a new value but there are different weights on the 5 different, sorry not 4, sets and I am VERY new at this.

Thanks for the help.

Re: How do I change a numeric grade to a letter grade?

art297 — Wed, 20 Nov 2013 01:19:46 GMT

Nothing wrong with being new, but explicitly describe what you want. The best way, I think, is to provide two files, both in the format of data step code: one showing an example of what you have; and the other showing what you want to achieve based on your sample data set.