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.