topic Re: Combine multiple If clauses to case when statement in SAS Programming

Combine multiple If clauses to case when statement

Babloo — Fri, 19 Oct 2018 05:13:10 GMT

Appreciate if someone of you guide me to combine the following if clauses to 'case when...' statement. I want to calculate the variable 'knkbty' and it should have values 1,3,4,5,6.

Re: Combine multiple If clauses to case when statement

s_lassen — Wed, 10 Oct 2018 11:40:40 GMT

That's kinda messy code, and not workable (there are two unclosed DO blocks). Disregarding the hanging DO statements, I think that what you want may be something like this:

case
  when knkatd ne knkatd_v then '6'
  when agi ne agi_v then '1'
  when knbjpn > knbjpn_v then '3'
  when knkvpb in ('1','2','3') and knkvpb_v in ('4','5') then '3'
  when knkvpb in ('4','5') and knkvpb_v in ('1','2','3') then '3'
  when knbjpn < knbjpn_v then '4'
  else '5'
end

Re: Combine multiple If clauses to case when statement

mkeintz — Wed, 10 Oct 2018 15:18:40 GMT

Your first if group tests on the relationship between knbjpn and knbjpn_v, and it exhausts all possible relations (you have one <, one > and one for =).

So your subsequent tests on AGI and KNKATD, if true, will supersede results based on knbjpn. Is that intentional?

Assuming it is, that's why @s_lassen's response reverses the order of the 3 main IF test groups, but maintains the order within the first group (if, else if, else).

Re: Combine multiple If clauses to case when statement

Babloo — Thu, 11 Oct 2018 05:16:12 GMT

Thank you. How to add the below condition in the following case when code to derive the value for KNKBTY=2 apart from 1,3,4,5 and 6?

  if agi ne agi_v           
    then do;                
      knkbty = '1';         
      knkatv = '' ;         
      knkath = '' ;         
      agiteg = agi;         
      link schrijfv;        
   else                        
      knkbty = '2';         
      knkatv = '' ;         
      knkath = '' ;         
      agiteg = agi_v;

Case when statement which I have right now is as below. I've to add the above condition in the case when to derive value for '2' as well.

case
  when knkatd ne knkatd_v then '6'
  when agi ne agi_v then '1'
  when knbjpn > knbjpn_v then '3'
  when knkvpb in ('1','2','3') and knkvpb_v in ('4','5') then '3'
  when knkvpb in ('4','5') and knkvpb_v in ('1','2','3') then '3'
  when knbjpn < knbjpn_v then '4'
  else '5'
end