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

Cfert13 — Tue, 05 Mar 2019 01:18:25 GMT

Hi all, I am attempting to use Proc SQL to combine values (Total_XP_Made) of specific players (as each player has multiple observations within the data set) based on a dummy variable I have created along with it (Pre_or_post_change). Below is the code itself, let me know if additional information is needed.

proc sql;
create table KID1 as
select distinct a.player, a.pre_or_post_change, a.Total_XP_made,
(case
when a.pre_or_post_change = 0 then sum(a.Total_XP_Made)
else 'None'
end) as XpMade
from KickersInfoDiff as a
group by Player;
quit;

Re: ERROR: Result of WHEN clause 2 is not the same data type as the preceding results.

kiranv_ — Tue, 05 Mar 2019 03:33:41 GMT

problem is (case
when a.pre_or_post_change = 0 then sum(a.Total_XP_Made)
else 'None'
end)

you have sum(a.Total_XP_Made) and 'None' for same variable XpMade, of which one value is numeric and another one is character

Try change 'None' to .( a missvalue for numeric variable)

topic ERROR: Result of WHEN clause 2 is not the same data type as the preceding results. in New SAS User

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

Re: ERROR: Result of WHEN clause 2 is not the same data type as the preceding results.