topic Re: Sum a case statement in SAS Programming

Sum a case statement

Cheesiepoof05 — Wed, 30 Aug 2023 13:57:38 GMT

Hello, I'm using Proc SQL and have the following statement where I'm deriving a count field. My problem is I am trying to sum up the data and have fields I'm grouping by. Is it possible to SUM the case statement because I don't want each record splitting out on me and I have lots of other fields summing up?

CASE WHEN CODE = 'X' THEN -1 ELSE 1 END as COUNT,

Not working:

SUM (CASE WHEN CODE = 'X' THEN -1 ELSE 1 END as COUNT),

Re: Sum a case statement

Quentin — Wed, 30 Aug 2023 14:20:40 GMT

Your close parenthesis is in the wrong spot. Try:

SUM (CASE WHEN CODE = 'X' THEN -1 ELSE 1 END) as COUNT

Re: Sum a case statement

Cheesiepoof05 — Wed, 30 Aug 2023 14:50:49 GMT

Thank you!