Hi,
How do I write a case sum statement please? I have tried to write one but not 100% sure of the syntax?
proc sql;
create table R.TESTING_SUM as
select
date,
sum
(case when 'F1S','F2S','F3S','F4S','F5S','F6S') as FS_NEW,
sum
(case when 'F1V','F2V','F3V','F4V','F5V','F6V') as FS_NEW,
from test.testing;
quit;
Thanks