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

[Mark7807]

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

[ballardw]

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;

[Mark7807]

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.

[art297]

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.