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

Reply
New Contributor
Posts: 2

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

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

Super User
Posts: 11,343

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

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;

New Contributor
Posts: 2

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

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.

PROC Star
Posts: 7,492

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

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.

Ask a Question
Discussion stats
  • 3 replies
  • 272 views
  • 0 likes
  • 3 in conversation