https://communities.sas.com/t5/SAS-Programming/ERROR-Result-of-WHEN-clause-2-is-not-the-same-data-type/m-p/514671#M138792 <P>I'm receiving the error as &nbsp;'ERROR: Result of WHEN clause 2 is not the same data type' while I tried to execute the following case when statement. Could you please help me understand the likely cause for this issue? Both the variables KHIREF and KHIREF1 are character variables.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">case when KHIREF1 ne " " then KHIREF=KHIREF1 else KHIREF end</CODE></PRE> Tue, 20 Nov 2018 05:36:33 GMT Babloo 2018-11-20T05:36:33Z https://communities.sas.com/t5/SAS-Programming/ERROR-Result-of-WHEN-clause-2-is-not-the-same-data-type/m-p/514671#M138792 <P>I'm receiving the error as &nbsp;'ERROR: Result of WHEN clause 2 is not the same data type' while I tried to execute the following case when statement. Could you please help me understand the likely cause for this issue? Both the variables KHIREF and KHIREF1 are character variables.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">case when KHIREF1 ne " " then KHIREF=KHIREF1 else KHIREF end</CODE></PRE> Tue, 20 Nov 2018 05:36:33 GMT https://communities.sas.com/t5/SAS-Programming/ERROR-Result-of-WHEN-clause-2-is-not-the-same-data-type/m-p/514671#M138792 Babloo 2018-11-20T05:36:33Z https://communities.sas.com/t5/SAS-Programming/ERROR-Result-of-WHEN-clause-2-is-not-the-same-data-type/m-p/514673#M138793 <P>In your case-expression KHIREF<SPAN class="token operator">=</SPAN>KHIREF1 is a logical value (numeric). You probably want</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">case when KHIREF1 ne " " then KHIREF1 else KHIREF end</CODE></PRE> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 20 Nov 2018 05:42:02 GMT https://communities.sas.com/t5/SAS-Programming/ERROR-Result-of-WHEN-clause-2-is-not-the-same-data-type/m-p/514673#M138793 PGStats 2018-11-20T05:42:02Z