topic Re: Case Expression in SAS Programming

Case Expression

parmis — Thu, 16 Aug 2018 14:01:30 GMT

Hello SAS Users,

I'm trying to submit the following case when expression and I get the error message that components are of different types.

PROC SQL;

CREATE TABLE work.test AS SELECT * ,

CASE WHEN CLI in ('4244','6454654') THEN 'Approved'

END AS status,

case when apps in ('25','5') then 'In process'

else 'other' end as req

from work.info

quit;

I appreciate your help

RW9 — Thu, 16 Aug 2018 14:06:00 GMT

Well its either:

case when cli in (4244,6454654) then 'Approved' end as status,

Or:

case when apps in (25,5) then 'In process' else 'other' end as req

Or both. Basically your comparing a variable of type numeric to character or vice versa.

If you had provided either/or - test data in the form of a datastep, the actual log output, I could be more specific.