topic Re: More then one column in Select When statements in SAS Programming

More then one column in Select When statements

sas121987 — Fri, 07 Mar 2014 16:47:56 GMT

Hello how to use conditions on two columns with select when statements:

I am not getting any errors, but my results are not correct. I want to set the new variable x based on the col1 and col2 conditions using select when only. Please find my code below.

data test;

input col1 $ col2;

length x $10;

datalines;

A 1

A 2

A 3

B 1

B 2

B 3

C 1

;;

run;

data test2;

set test;

select (col1);

when (A) do;

if col2 = 1 then do;

x= 'test_A1';

end;

when (B) do;

if col2 = 3; then do;

x = 'test_B3 ';

end;

otherwise put 'other';

end;

Thanks.

Re: More then one column in Select When statements

Peter_C — Fri, 07 Mar 2014 17:19:34 GMT

something like

select ;

when (col1='A' and col2 = 1 ) do;

x= 'test_A1';

end;

when (col1='B' and col2 = 3 ) do;

x = 'test_B3 ';

end;

otherwise put 'other';

end;

Re: More then one column in Select When statements

sas121987 — Fri, 07 Mar 2014 17:47:28 GMT

Thanks Peter, It worked.