topic Re: if else question in SAS Procedures

if else question

GeorgeSAS — Mon, 11 Apr 2016 01:25:27 GMT

Hello everyone,

need 1 not works but simple,I want the result as need2, but can't I omiss 'a=1' in need 2?

data have;
a=1;b=2;c=3; output;
a=100;b=20;c=30;output;
a=1;b=20;c=30;output;
run;

data need1;
k=0;
set have;
if a=1 and b=2 then k=1;
else if b=20 then k=2;
run;

data need2;
k=0;
set have;
if a=1 and b=2 then k=1;
else if a=1 and b=20 then k=2;
run;

Thanks

Re: if else question

Reeza — Mon, 11 Apr 2016 02:04:13 GMT

Are you trying to create a counter by a variable?

Your logic is hardcoded, you need to generalize your logic so that it will work in more situations.

Re: if else question

Kurt_Bremser — Mon, 11 Apr 2016 06:11:45 GMT

if a=1
then do;
  if b=2
  then k=1;
  else if b=20
  then k=2;
end;

is equivalent to yor need2 condition.