topic Re: IF THEN STATEMENT in SAS Procedures

IF THEN STATEMENT

R_A_G_ — Mon, 28 Mar 2011 17:34:53 GMT

Hello,

I am using IF Then statement to label my binary data by their combination. I have 3 binary variables which means 2**3=7 combination:
this is my data:
A B C
1 1 1
0 0 1
and so on

so, the first row will be combination 8, 2nd combination 1,....
Right now I am using IF Then statement which means 8 lines of "if then" how can I avoid this and use a shorter code?
thank you

Re: IF THEN STATEMENT

RickM — Mon, 28 Mar 2011 17:56:57 GMT

You could do something like...

comb=input(catx(put(A,1.),put(B,1.),put(C,1.)),binary3.);

Good luck!

Re: IF THEN STATEMENT

R_A_G_ — Mon, 28 Mar 2011 18:06:15 GMT

Thanks Rick,
it worked I replaced my code with yours (had to switch 1st statemment with the 2nd). Do you mind explaining what your code did.
Thanks again

this was my code(long:)):
IF SKILLS1=0 and SKILLS2=0 AND SKILLS3=1 THEN COMBINATION=1;
if SKILLS1=0 and SKILLS2=1 AND SKILLS3=0 THEN COMBINATION=2;
IF SKILLS1=0 and SKILLS2=1 AND SKILLS3=1 THEN COMBINATION=3;
IF SKILLS1=1 and SKILLS2=0 AND SKILLS3=0 THEN COMBINATION=4;
IF SKILLS1=1 and SKILLS2=0 AND SKILLS3=1 THEN COMBINATION=5;
IF SKILLS1=1 and SKILLS2=1 AND SKILLS3=0 THEN COMBINATION=6;
IF SKILLS1=1 and SKILLS2=1 AND SKILLS3=1 THEN COMBINATION=7;

Re: IF THEN STATEMENT

RickM — Mon, 28 Mar 2011 18:43:49 GMT

It basically concatenated the 0's and 1's into a string ('111', '101', '001', etc) and then that string was converted to a number based on the binary informat.

You could also have calculated the binary number from the individual variables.

comb=A*2**2+B*2**1+C*2**0;

Re: IF THEN STATEMENT

R_A_G_ — Mon, 28 Mar 2011 22:25:15 GMT

thank you so much
R.A.G.

Re: IF THEN STATEMENT

Ksharp — Tue, 29 Mar 2011 01:25:01 GMT

It looks like you are doing convert binary into dec

[pre]
data _null_;
retain combination -1;
do skills1=0,1;
do skills2=0,1;
do skills3=0,1;
combination+1;
put (_all_) (:);
end;
end;
end;
run;
[/pre]

Ksharp