topic Re: Error: Result of when clause 8 is not same data type as the preceding results in SAS Programming

Error: Result of when clause 8 is not same data type as the preceding results

GN0001 — Sat, 03 Jul 2021 06:08:36 GMT

hello team,

I have a case statement, that all have character data type after then, but it gives me error message.

Regards,

blue blue

Re: Error: Result of when clause 8 is not same data type as the preceding results

Astounding — Sat, 03 Jul 2021 10:15:53 GMT

I baked a cake but it tastes funny. I did use eggs. What did I do wrong?

Re: Error: Result of when clause 8 is not same data type as the preceding results

PaigeMiller — Sat, 03 Jul 2021 11:08:40 GMT

Hello, @GN0001

You have been in this forum long enough now to know that when you get an error message, we need you to show us the LOG for this PROC.

INSTRUCTIONS FOR PROVIDING THE LOG: We need the ENTIRE log for this PROC, 100% of the log for this PROC, with nothing chopped out, every single character. Copy this portion of the log as text. Click on the </> icon and paste your log as text into the window that appears.

Re: Error: Result of when clause 8 is not same data type as the preceding results

Tom — Sat, 03 Jul 2021 12:42:11 GMT

@GN0001 wrote:

hello team,

I have a case statement, that all have character data type after then, but it gives me error message.

Regards,

blue blue

There is either a typo you are not seeing or the variables in the source dataset are not the data type you think they are.

Please show the code, preferable the log. Also show the definition of the input dataset(s).

Re: Error: Result of when clause 8 is not same data type as the preceding results

GN0001 — Sat, 03 Jul 2021 14:36:08 GMT

This is the code: This gives error and the affected code is where joins are: Thanks, blue blue

Proc sql;
create table table_out as
select distinct c.*,
case
when (not missing(25percentile) and rate *100 < 25percentile) then '<25'
when (not missing(25percentile) and rate *100 >=25percentile and rate <50percentile) then '25'
when (not missing(50percentile) and rate *100 >=50percentile and rate <75percentile) then '50'
when (not missing(75percentile) and rate *100 >=75percentile and rate <80percentile) then '75'
when(not missing (80percentile) and rate *100 >80percentile) then 'done'
else 'error'
end as thisjunk
, from lefttable c left join.....

Re: Error: Result of when clause 8 is not same data type as the preceding results

GN0001 — Sat, 03 Jul 2021 14:42:46 GMT

Hello team,

It is not doable for me to give you the entire log, it is my work computer. If it was my personal computer, I would have copied and send everything out.

I posted the code.

Thanks,

blue blue

Re: Error: Result of when clause 8 is not same data type as the preceding results

Tom — Sat, 03 Jul 2021 15:04:29 GMT

That code cannot work. You cannot have a variable whose name starts with a digit.

Re: Error: Result of when clause 8 is not same data type as the preceding results

Tom — Sat, 03 Jul 2021 15:11:21 GMT

Check carefully for unbalanced parentheses and unbalanced quotes. Especially if you really have named your variable starting with digits so that you need to use name literals to reference them. That means there are more chances to have messed up the quotes.

Re: Error: Result of when clause 8 is not same data type as the preceding results

GN0001 — Sat, 03 Jul 2021 16:17:36 GMT

Where are you referring?

Re: Error: Result of when clause 8 is not same data type as the preceding results

GN0001 — Sat, 03 Jul 2021 16:21:34 GMT

Re: Error: Result of when clause 8 is not same data type as the preceding results

GN0001 — Sat, 03 Jul 2021 16:22:39 GMT

Can you please let me know which line? I don’t have variables with digits!
Thanks
Blue green

Re: Error: Result of when clause 8 is not same data type as the preceding results

GN0001 — Sat, 03 Jul 2021 17:22:37 GMT

Here I put digit but in real world it starts with BQ_.

Thanks,

blue blue

Re: Error: Result of when clause 8 is not same data type as the preceding results

GN0001 — Sat, 03 Jul 2021 17:23:59 GMT

sorry, I noticed it, in real world it starts with letters. It is QB_25, QB_50,..

Thanks,

blue greeen

Re: Error: Result of when clause 8 is not same data type as the preceding results

Tom — Sat, 03 Jul 2021 18:01:58 GMT

Use a simple process of elimination to discover which WHEN clause is generating the wrong type of value.

Comment out some of the lines and see if the error is eliminated or not. Depending on the result comment out other sections until you have found the offending section (or sections).