topic Aggregating an aggregated variable. in SAS Visual Analytics

Aggregating an aggregated variable.

elkinsbe — Thu, 29 Jun 2023 13:01:44 GMT

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

Re: Aggregating an aggregated variable.

PaigeMiller — Thu, 29 Jun 2023 13:19:20 GMT

~~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.

Re: Aggregating an aggregated variable.

data_null__ — Thu, 29 Jun 2023 13:18:05 GMT

Visual Analytics

Re: Aggregating an aggregated variable.

elkinsbe — Thu, 29 Jun 2023 13:22:42 GMT

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

Re: Aggregating an aggregated variable.

acordes — Tue, 04 Jul 2023 10:50:48 GMT

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.

Re: Aggregating an aggregated variable.

elkinsbe — Tue, 11 Jul 2023 20:20:09 GMT

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