topic Result of when clause 2 is not the same data type in New SAS User

Result of when clause 2 is not the same data type

new_sas_user_4 — Fri, 04 Jan 2019 16:01:24 GMT

Hi,

I am writing a when clause saying:

case when put(AB,1.)='1' then XY='0' else XY end as XY

AB is numeric and so to put it in the case statement I converted it to char but it is still saying the error "Result of when clause 2 is not the same data type as the preceding results".

XY is character.

How can I put the case statement here !

Thanks in advance:)

Re: Result of when clause 2 is not the same data type

PaigeMiller — Fri, 04 Jan 2019 16:11:18 GMT

@new_sas_user_4 wrote:

Hi,

I am writing a when clause saying:

case when put(AB,1.)='1' then XY='0' else XY end as XY

AB is numeric and so to put it in the case statement I converted it to char but it is still saying the error "Result of when clause 2 is not the same data type as the preceding results".

XY is character.

How can I put the case statement here !

The expression XY='0' is a Boolean expression, it evaluates as either true or false which in SAS is a numeric one or zero. So you can't have a numeric in one case (when put(AB,1.)='1' then XY='0') and a character XY in the other case.

Try this:

case when AB=1 then '0' else XY end as XY

Re: Result of when clause 2 is not the same data type

new_sas_user_4 — Fri, 04 Jan 2019 16:23:56 GMT

Thanks a lot 🙂 🙂