SUM CASE Statement

KC_16 — Tue, 27 Feb 2018 18:19:21 GMT

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

Re: SUM CASE Statement

Satish_Parida — Tue, 27 Feb 2018 18:24:34 GMT

This is wrong(SQL Syntax Error) and the code does not make any sense.
Please post your requirement and data clearly.

topic SUM CASE Statement in SAS Programming

SUM CASE Statement

Re: SUM CASE Statement