title: Incompatible data types in CASE STATEMENT
body: <p>I am converting a SAS code into Cognos Report Studio version 10 where am stuck at a point where there is data formatting needed. </p>
  
  <pre><code>IF SDW_STAT ^= '' THEN PRINCIPAL_BAL = TOT_PRIN;
  </code></pre>
  
  <p>Where '' represnts single quotes without any space</p>
  
  <p>I tried writing a <code>CASE STATEMENT</code>:</p>
  
  <pre><code>CASE 
  WHEN ([SDW_STAT] IS NOT MISSING) THEN ([PRINCIPAL_BAL] = [TOT_PRIN])
  ELSE ('') 
  END
  </code></pre>
  
  <p>I also tried couple of options like <code>&lt;&gt; '', is not null, &lt;&gt; ' '</code> instead of <code>IS NOT MISSING</code> but none of them worked. Can you please suggest where I am going wrong?
  Pls note: SDW_STAT column has few blank fields and some characters like 'Y' 'S' etc.</p>