DATA Step, Macro, Functions and more

SUM CASE Statement

Reply
Occasional Contributor
Posts: 18

SUM CASE Statement

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

Frequent Contributor
Posts: 109

Re: SUM CASE Statement

This is wrong(SQL Syntax Error) and the code does not make any sense.
Please post your requirement and data clearly.
Ask a Question
Discussion stats
  • 1 reply
  • 251 views
  • 0 likes
  • 2 in conversation