Aggregating an aggregated variable.

[elkinsbe]

How does one aggregate an aggregated variable?.... seems like a simple question, but I have an aggregated variable that yields a flag value of 0 or 1... now I wish to sum this variable (I want to get the sum of the 1's).. but I keep getting an error telling me "one cannot aggregate an aggregated variable.".... Anyone out there have an idea how to avoid this??? Thank so much in advance for your assistance.... - Ben

[PaigeMiller]

---

---

I have never seen such an error message. What SAS user interface are you using? Could you please provide the actual code you are using and the ENTIRE log from the step where the error appears?

OK, I see this is a question about SAS Visual Analytics, so I withdraw my question.

[data_null__]

Visual Analytics

[elkinsbe]

Yes... this is VA... apologies, should have mentioned that....

[acordes · Accepted solution]

The easiest way is to create the aggregated measure at first place and then create an aggregated table. 

This converts the aggregated measure to a numeric static variable on which you can operate with your sum calculation.

[elkinsbe]

Thank you! .... it's the Kobayashi Maru 😎