Sum a case statement

[Cheesiepoof05]

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),

[Quentin · Accepted solution]

Your close parenthesis is in the wrong spot.  Try:

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

[Cheesiepoof05]

Thank you!