topic Score bands in SAS Programming

Score bands

Solly7 — Tue, 30 Mar 2021 06:46:17 GMT

Hi, i need help in creating a new column which will be used to assign scores based on the below bands:

if qa_score < 90 then Score = 0

if qa_score >= 90 and qa_score < 92.5 then Score = 0.04

if qa_score >= 92.5 and qa_score < 95 then Score = 0.08

if qa_score >= 95 and qa_score < 97.5 then Score = 0.12

if qa_score >= 97.5 and qa_score < 100 then Score = 0.16

if qa_score = 100 then Score = 0.20

data have; input policy_no QA_score; datalines; 1 88 2 91 3 94 4 96 5 99 6 100 ;

data WANT

policy_no Score

1 0

2 0.04

3 0.08

4 0.12

5 0.16

6 0.20

Re: Score bands

andreas_lds — Tue, 30 Mar 2021 06:55:48 GMT

Sorry, but i don't see the problem. You have already posted the necessary statements to create the variable "score", so: what is the problem?

Using a format instead of if-statements is recommended, but this is up to you.

Re: Score bands

PeterClemmensen — Tue, 30 Mar 2021 06:59:07 GMT

Try this

proc format;
   invalue s
      low  -< 90   = 0
      90   -< 92.5 = 0.04
      92.5 -< 95   = 0.08
      95   -< 97.5 = 0.12
      97.5 -< 100  = 0.16
      100  - high = 0.2
   ;
run;

data have;
input policy_no QA_score;
datalines;
1 88  
2 91  
3 94  
4 96  
5 99  
6 100 
;

data want;
   set have;
   score = input(QA_score, s.);
run;

Re: Score bands

japelin — Tue, 30 Mar 2021 06:59:14 GMT

If you want to make it shorter, you can use the following code.

data want;
  set have;
  if      qa_score < 90   then Score = 0;
  else if qa_score < 92.5 then Score = 0.04;
  else if qa_score < 95   then Score = 0.08;
  else if qa_score < 97.5 then Score = 0.12;
  else if qa_score < 100  then Score = 0.16;
  else if qa_score = 100  then Score = 0.20;
  drop qa_score;
run;

Re: Score bands

Solly7 — Tue, 30 Mar 2021 12:22:48 GMT

Thank you, it works perfectly fine.

Re: Score bands

PeterClemmensen — Tue, 30 Mar 2021 14:01:36 GMT

Anytime.