topic Re: If and else in New SAS User

If and else

dooheekim01 — Sun, 20 Dec 2020 16:42:42 GMT

The question :

create results.output36 from cleandata36
Ensure that all values for variable Kilograms are between 40 and 200, inclusively.
If the value is missing or out of range, replace the value with the MEDIAN Kilograms value for the respective group (A,B) calculated in step 2.

The answer is :

data results.output36;
set cleandata36;
if Kilograms < 40 or Kilograms > 200 then do;
if group='A' then kilograms=79;
else kilograms=89;
end;
run;

My question is that:

if Kilograms <40 or Kilograms > 200 then do;

else group='A' then kilograms=79;

didn't work.

My question is why I should not use 'else' in red. It is hard to understand. Thank you so much for your help.

Re: If and else

Shmuel — Sun, 20 Dec 2020 08:40:51 GMT

1) DO; needs to be closed by END;

2) ELSE <do something>;

Your code:

if Kilograms <40 or Kilograms > 200 then DO;
   /* option 1*/ <do something is optional>; END;
else /* 40 <= Kilograms <= 200 >
  group='A' ;  /* then needs to be preceded by IF*/
   kilograms=79; /* Is this part of the IF? of the ELSE? or always ? */

If you have more than one statement to do conditionally enclose then between DO: and END;

Re: If and else

dooheekim01 — Sun, 20 Dec 2020 16:44:06 GMT

Thank you so much, Shmuel!

Re: If and else

anming — Sun, 20 Dec 2020 17:59:08 GMT

data result.output36;
set result.cleandata36;
if 40 <= kilograms le 200 then kilograms=kilograms;
else if group ='A' then kilograms=79;
else if group ="B" then kilograms=89;

run;

alternatively, you can code like above. 'then' for one action, 'do' for multiple actions and finish with 'end'.

Re: If and else

dooheekim01 — Sun, 20 Dec 2020 23:37:52 GMT

Thank you so much, Anming. It was really helpful!