Multiple IF then statements query

[librasonali]

hello users !

Given the following SAS data set WORK.TOYS:

  Product            Group               Price
  ---------          -----------          -----
  Cards              Indoors                9.99
  Marbles          Indoors                8.99
  Drum              Instruments        12.99
  Hula-Hoop     Outdoors            12.99
  Ball                 Outdoors              8.49

The following SAS program is submitted:

data WORK.GROUPS;
   set WORK.TOYS;
   if Group="Outdoors" then Price_Gp="C";
   if Price ge 12.99 then Price_Gp="A";
   else if Price ge 8.99 then Price_Gp="B";
run;

What will be the value of Price_Gp for Hula-Hoop and Ball?

Answer is Hula-Hoop: 'A',  Ball: 'C'

Why answer is not  Hula-Hoop: 'C',  Ball: 'C ?? can pls someone help. Thanks in advance 🙂

[PeterClemmensen]

Because the else if statement is only executed if the initial if statement is not true 🙂

[PaigeMiller · Accepted solution]

The line 

if Price ge 12.99 then Price_Gp="A";

executes and sets the Price_Gp value to "A" for Hula-Hoop. This overwrites the value of Price_Gp="C" that was obtained in the previous line.

Since you don't want that, you need to make sure the above line does not execute for Hula-Hoop. This code would look like

data WORK.GROUPS;
   set WORK.TOYS;
   if Group="Outdoors" then Price_Gp="C";
   ELSE if Price ge 12.99 then Price_Gp="A";
   else if Price ge 8.99 then Price_Gp="B";
run;

Now, for Outdoors toys, the lines that check the Price will not be used; and for toys that are not Outdoors, the price checks are the only lines that will be used.

[Ksharp]

It is overwrited by this :
if Price ge 12.99 then Price_Gp="A";