topic WHEN clause with multiple conditions in SAS Programming

WHEN clause with multiple conditions

kenjichan1212 — Wed, 31 Jul 2019 06:44:06 GMT

Hi all I'm new to SAS and I'm just wondering why I am getting the error below:

ERROR: Result of WHEN clause 3 is not the same data type as the preceding results

Here is my code

case

WHEN Year = 1617 and state in ('NSW') and Surgical_Specialty = '12' then Surgical_Specialty = '11'

WHEN Year = 1617 and t1.state in ('NT') and Surgical_Specialty in ('01','1') then Surgical_Specialty = '11'

ELSE Surgical_Specialty end as Surgical_Specialty,

The Year column is in Numeric

The Surgical_Specialty and STATE is in Character

Not sure why I cannot use year and STATE and surgical specialty in one when statement

Thankyou

ChrisNZ — Wed, 31 Jul 2019 06:50:09 GMT

Use the correct syntax.

Your 2 first when clauses return a Boolean (the result of the test Surgical_Specialty = '11')

CASE

WHEN Year = 1617 and state in ('NSW') and Surgical_Specialty = '12' then '11'

WHEN Year = 1617 and state in ('NT ') and Surgical_Specialty in ('01','1') then '11'

ELSE Surgical_Specialty END as Surgical_Specialty

kenjichan1212 — Wed, 31 Jul 2019 06:54:42 GMT

Thank you so mcuh!