SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
Cheesiepoof05
Obsidian | Level 7

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

1 ACCEPTED SOLUTION

Accepted Solutions
Quentin
Super User

Your close parenthesis is in the wrong spot.  Try:

SUM (CASE WHEN CODE = 'X' THEN -1 ELSE 1 END) as COUNT
The Boston Area SAS Users Group is hosting free webinars!
Next up: Troy Martin Hughes presents Calling Open-Source Python Functions within SAS PROC FCMP: A Google Maps API Geocoding Adventure on Wednesday April 23.
Register now at https://www.basug.org/events.

View solution in original post

2 REPLIES 2
Quentin
Super User

Your close parenthesis is in the wrong spot.  Try:

SUM (CASE WHEN CODE = 'X' THEN -1 ELSE 1 END) as COUNT
The Boston Area SAS Users Group is hosting free webinars!
Next up: Troy Martin Hughes presents Calling Open-Source Python Functions within SAS PROC FCMP: A Google Maps API Geocoding Adventure on Wednesday April 23.
Register now at https://www.basug.org/events.
Cheesiepoof05
Obsidian | Level 7
Thank you!

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1398 views
  • 0 likes
  • 2 in conversation