topic Re: Substract the average of a column from all datasets of the column in SAS Visual Analytics

Substract the average of a column from all datasets of the column

Yanoothan — Sat, 23 Jul 2022 14:57:01 GMT

Hi,

I have a column named 'He_abs' with different datasets. I want to calculate the average of all dataset values of the column and then substract the average from all the dataset values in SAS VA.

Therefor I tried to create a calculated item with the expression 'He_abs' - Avg [_ForAll_] ('He_abs').

That does not work and i get the warnings 'element can't be aggregated' and 'operator does not support aggregation'.

How can I perform the calculation in SAS VA?

Thanks

Re: Substract the average of a column from all datasets of the column

acordes — Mon, 25 Jul 2022 08:25:49 GMT

If you have licenced Visual Statistics then use a GLM to have a dummy model for predicting the mean.

Probabably you have to create a dummy character variable to use an overall effect.

Then use the variable of interest as target and the dummy variable as classifiaction effect.

Once the model has finished, derive predicted, that's your grand mean you can use in a calculated item 'x-y'.

Re: Substract the average of a column from all datasets of the column

Yanoothan — Mon, 25 Jul 2022 09:35:49 GMT

Hi,

thanks for your answer. But does that mean that the calculation is not possible only using SAS VA?

Re: Substract the average of a column from all datasets of the column

acordes — Mon, 25 Jul 2022 09:44:41 GMT

You can do it in Visual Analytics.

What I recommend goes for Visual Analytics.

You can achieve this as well by creating an aggregated data source. You first create an aggregated item like mean by total.

Then aggregate the data source. This way it's easier to deal with it because now the grand total mean becomes a scalar value.