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

[Cfert13]

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;

[kiranv_]

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)