topic Re: IF-THEN/ELSE Statement in SAS Programming

IF-THEN/ELSE Statement

marcuswong — Tue, 08 Sep 2020 04:02:35 GMT

Hi Members,

In the SAS documentation, it says " The ELSE statement, if used, must immediately follow the IF-THEN statement."

I am trying to understand the above meaning but is confused when the below codes are valid and at line 6, the else statement does not immediately follow the if-then statement.

Anyone can enlighten me?

data storm_cat;
    set pg1.storm_summary;
    keep Name Basin MinPressure StartDate PressureGroup;
    if MinPressure=. then PressureGroup=.;
    else if MinPressure<=920 then PressureGroup=1;
    else PressureGroup=0;
run;

Re: IF-THEN/ELSE Statement

SASKiwi — Tue, 08 Sep 2020 04:29:35 GMT

That's true when you have only one ELSE statement, but if you have more than one ELSE, then they can follow one after the other as long as the first ELSE in the sequence is preceded by an IF statement.

Re: IF-THEN/ELSE Statement

ChrisNZ — Tue, 08 Sep 2020 07:54:52 GMT

> the else statement does not immediately follow the if-then statement.

It does.

data storm_cat;
    set pg1.storm_summary;
    keep Name Basin MinPressure StartDate PressureGroup;
    if MinPressure=. then PressureGroup=.;
    else if MinPressure<=920 then PressureGroup=1;
    else PressureGroup=0;
run;

The red ELSE follows the red IF, and the blue ELSE follows the blue IF.

The catch here is that the blue IF has been made part of the red ELSE statement, hence the confusion. If DO blocks were used, the sequence would be (slightly) clearer.

The bottom line is this: you cannot use a ELSE statement when there is not a corresponding IF-THEN just before.

Re: IF-THEN/ELSE Statement

marcuswong — Fri, 11 Sep 2020 09:29:01 GMT

@SASKiwiand @ChrisNZ Thank you for the guidance!

Re: IF-THEN/ELSE Statement

Tom — Fri, 11 Sep 2020 12:01:47 GMT

Not sure why you are confused. You have two ELSE and two THEN. Perhaps if you changed your indentation style it would be clearer?

if MinPressure=. then PressureGroup=.;
                 else if MinPressure<=920 then PressureGroup=1;
                                          else PressureGroup=0;

Re: IF-THEN/ELSE Statement

marcuswong — Sat, 26 Sep 2020 02:18:19 GMT

@Tom I misinterpret the sentence in the SAS documentation that after "else" must follow by "if-then".

instead, I should learn it as ''else" cannot be used alone and "else" must always follow behind a "if-then".

Please let me know if I am learning correctly?

Re: IF-THEN/ELSE Statement

Kurt_Bremser — Sat, 26 Sep 2020 13:14:23 GMT

To help you understand the code, let's expand it a little, and slightly change the indentation:

data storm_cat;
set pg1.storm_summary;
keep Name Basin MinPressure StartDate PressureGroup;
if MinPressure = .
then PressureGroup = .;
else do;
  if MinPressure <= 920
  then PressureGroup = 1;
  else PressureGroup = 0;
end;
run;

So you can see that the second if-then-else follows the exact same pattern as the first if-then-else.

Since, logically, a if-then-else can be used as a single statement, the do/end can be omitted, leading to this:

if MinPressure = .
then PressureGroup = .;
else if MinPressure <= 920
then PressureGroup = 1;
else PressureGroup = 0;

which is what you have originally.

Re: IF-THEN/ELSE Statement

Tom — Sat, 26 Sep 2020 13:50:34 GMT

Sounds like an issue with understanding the complexities of English language. The phrase "x follows y" and "x is followed by y" imply opposite orders for X and Y. The first means the sequence is Y -> X and the second means X -> Y.

Re: IF-THEN/ELSE Statement

marcuswong — Mon, 28 Sep 2020 10:07:22 GMT

@Tom @Kurt_BremserThank you for the guidance!