I'm receiving the error as '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.
case when KHIREF1 ne " " then KHIREF=KHIREF1
else KHIREF
end
In your case-expression KHIREF=KHIREF1 is a logical value (numeric). You probably want
case when KHIREF1 ne " " then KHIREF1
else KHIREF
end
In your case-expression KHIREF=KHIREF1 is a logical value (numeric). You probably want
case when KHIREF1 ne " " then KHIREF1
else KHIREF
end
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.