Case Expression

[parmis]

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]

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.