topic Re: Multiple IF then statements query in New SAS User

Multiple IF then statements query

librasonali — Wed, 04 Nov 2020 11:29:48 GMT

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 🙂

Re: Multiple IF then statements query

PeterClemmensen — Wed, 04 Nov 2020 11:37:13 GMT

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

Re: Multiple IF then statements query

PaigeMiller — Wed, 04 Nov 2020 11:38:34 GMT

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.

Re: Multiple IF then statements query

Ksharp — Wed, 04 Nov 2020 11:48:33 GMT

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