topic Re: quasi-complex if-then structures in SAS Programming

quasi-complex if-then structures

emaguin — Mon, 02 Dec 2019 18:43:46 GMT

Long time spss user. I want to see what the sas equivalent is for this.

do if (x eq 1 and y eq 3).

compute a=2.

compute b=3.

compute c=7.

else if (x eq 2 and y eq 4).

compute a=1.

compute b=0.

compute c=4.

else.

compute a=4.

compute b=5.

compute c=9.

end if.

or do if have to do this three times, subbing in b and c for a?

if (x eq 1 and y eq 3) then compute a=2;

else if (x eq 2 and y eq 4) then compute a=1;

else then compute a=4; /* this line may not be correct */;

Thanks, Gene Maguin

Re: quasi-complex if-then structures

ballardw — Mon, 02 Dec 2019 18:58:56 GMT

@emaguin wrote:

Long time spss user. I want to see what the sas equivalent is for this.

do if (x eq 1 and y eq 3).

compute a=2.

compute b=3.

compute c=7.

else if (x eq 2 and y eq 4).

compute a=1.

compute b=0.

compute c=4.

else.

compute a=4.

compute b=5.

compute c=9.

end if.

or do if have to do this three times, subbing in b and c for a?

if (x eq 1 and y eq 3) then compute a=2;

else if (x eq 2 and y eq 4) then compute a=1;

else then compute a=4; /* this line may not be correct */;

Thanks, Gene Maguin

if (x eq 1 and y eq 3) then do;
   a=2;
   b=3;
   c=7;
end;
else if (x eq 2 and y eq 4) then do;
   a=1;
   b=0;
   c=4;
end;
else do;
   a=4;
   b=5;
   c=9;
end ;

Please post code or log entries into a code box opened using the forum's {I} icon to preserve formatting and to prevent the forum from inserting additional new line characters.

Re: quasi-complex if-then structures

tomrvincent — Mon, 02 Dec 2019 18:59:37 GMT

data foo;
	x=1;
	y=3;

	if (x eq 1 and y eq 3) then
		do;
			a=2;
			b=3;
			c=7;
		end;
	else if (x eq 2 and y eq 4) then
		do;
			a=1;
			b=0;
			c=4;
		end;
	else
		do;
			a=4;
			b=5;
			c=9;
		end;
run;

Re: quasi-complex if-then structures

PGStats — Mon, 02 Dec 2019 19:07:59 GMT

I don't know about SPSS, by SAS syntax is fully described and explained in the documentation. You could start here, for example:

https://documentation.sas.com/?docsetId=basess&docsetTarget=p1n2fl39v0v2ffn1m3vm4a9kz2e5.htm&docsetVersion=9.4&locale=en

Re: quasi-complex if-then structures

ChrisHemedinger — Mon, 02 Dec 2019 19:46:03 GMT

If a SELECT-WHEN (or CASE-WHEN in SQL) is more in line with your mental model, you can use SELECT-WHEN-OTHERWISE.

data in;
  x=1;  y=3;
  output;
  x=2;  y=4;
  output;
  x=0;  y=0;
  output;
run;

data foo;
  set in;
  select;
   when (x eq 1 and y eq 3) 
    do;
      a=2; b=3; c=7;
    end;
   when (x eq 2 and y eq 4)
    do;
      a=1; b=0; c=4;
    end;
  otherwise
    do;
      a=4; b=5; c=9;
    end;
  end;
run;