Result of When clause 2 is not the same data type as preceding results

[wlierman]

I am trying to execute a query to search for keywords from ICD10 codes and receive the error written in the Subject line. My query follows:

Proc sql noprint;
Create table NCI_Out.Conditions_Flags As
Select Distinct RecipientID,
ClaimType As Condition Label 'Condition',
Gender,
Medicare_status,
Month,
CASE
When Primary_Dx_Desc Like '*Depress%'
Then Condition = 'Depression'
Else ' '
End As BI12_01,
Case
When Primary_Dx_Desc Like '*Schizo%'
Then Condition = 'Schizophrenia'
Else ' '
End As BI12_02,
Case
When Primary_Dx_Desc Like '*BiPol%'
Then Condition = 'BiPolar'
Else ' '
End As BI12_03,
Case
When Primary_Dx_Desc Like '*Mood%'
Then Condition = 'Mood_Disorder'
Else ' '
End As BI12_04,
Case
When Primary_Dx_Desc Like '*Anxiety%'
Then Condition = 'Anxiety_Disorder'
Else ' '
End As BI12_05,
Case
When Primary_Dx_Desc Like '*Chemical%'
Then Condition = 'Chemical_Dependence'
Else ' '
End As BI12_06,
Case
When Primary_Dx_Desc Like '*Opiate%'
Then Condition = 'Chemical_Dependence'
Else ' '
End As BI12_06a,
Case
When Primary_Dx_Desc Like '*Opiod%'
Then Condition = 'Chemical_Dependence'
Else ' '
End As BI12_06b
From NCI_Out.ICD10_Text_Check_ok
Order by RecipientID, Month;
Quit;Proc sql noprint;

I appreciate any help that is offered.

[ballardw]

It may help to show the entire Proc SQL from the log along with all error messages or notes. Best is to copy from the log and paste into a code box opened using the forum's {I} or "running man" icon to preserver the formatting of any error messages. Many errors include indicators of where the problem was detected and the main message windows will reformat text moving the indicators.

[Tom · Accepted solution]

So the ELSE clause is specifying a character string, but after the THEN you have a boolean expression that is testing whether the variable Condition has the value 'Depression' or not.

I assume that you actually meant:

when Primary_Dx_Desc like '*Depress%' then 'Depression'
else ' '
end as BI12_01

[wlierman]

Tom,

Thank you for the post. 

Making the change you provided cleared up the error.

Thank you for the solution.

Walt