DATA Step, Macro, Functions and more

More then one column in Select When statements

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

More then one column in Select When statements

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 1

A 2

A 3

B 1

B 2

B 3

C 1

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;

end;

Thanks.



Accepted Solutions
Solution
‎03-07-2014 12:19 PM
Valued Guide
Posts: 2,175

Re: More then one column in Select When statements


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;

View solution in original post


All Replies
Solution
‎03-07-2014 12:19 PM
Valued Guide
Posts: 2,175

Re: More then one column in Select When statements


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;

Occasional Contributor
Posts: 6

Re: More then one column in Select When statements

Thanks Peter, It worked.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 185 views
  • 0 likes
  • 2 in conversation