topic Re: Problem with aggregating data in SAS Visual Analytics in SAS Visual Analytics

Problem with aggregating data in SAS Visual Analytics

ZoeZoe — Mon, 24 Jan 2022 18:32:04 GMT

In SAS visual analytics, removing the date column causes the aggregate measures return to missing. Is it possible to avoid this? if yes how?

Re: Problem with aggregating data in SAS Visual Analytics

Sam_SAS — Mon, 24 Jan 2022 18:45:03 GMT

If your aggregated measures use periodic operators like CumulativePeriod(), the date column that they are based on must be included in your report objects. I don't think there's any workaround to this.

In other words, it is expected for the aggregated measures to return missing when the required dates are not present.

Sam

Re: Problem with aggregating data in SAS Visual Analytics

ZoeZoe — Mon, 24 Jan 2022 18:51:00 GMT

Thanks for your answer. Is it possible to aggregate the data and put it in a new column in the existing table by using Data Step (in the prepare data)?

Re: Problem with aggregating data in SAS Visual Analytics

Sam_SAS — Mon, 24 Jan 2022 19:00:04 GMT

I believe that it would be possible, yes. When you pre-aggregate the data in your preparation stage, the values might not reflect the effects of report filters. So be aware of that limitation.

Re: Problem with aggregating data in SAS Visual Analytics

ZoeZoe — Mon, 24 Jan 2022 19:09:15 GMT

Thanks a lot :). Do you have any idea what codes should I use?

should I look at the "group" function?

Re: Problem with aggregating data in SAS Visual Analytics

Sam_SAS — Mon, 24 Jan 2022 19:18:37 GMT

I don't have a lot of expertise on the data preparation stage. To help other users help you, please show or describe the aggregated expressions that you need to replace.

Thanks,
Sam

Re: Problem with aggregating data in SAS Visual Analytics

ZoeZoe — Mon, 24 Jan 2022 21:12:28 GMT

Thanks a lot for help.

Re: Problem with aggregating data in SAS Visual Analytics

SASKiwi — Wed, 26 Jan 2022 01:46:44 GMT

PROC SUMMARY or PROC SQL using the SUM function with GROUP BY are two common ways to aggregate data.

Re: Problem with aggregating data in SAS Visual Analytics

ZoeZoe — Wed, 26 Jan 2022 05:38:19 GMT

Does it aggregate and add them to an existing table?