Problem with aggregating data in SAS Visual Analytics

[ZoeZoe]

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

[Sam_SAS]

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

[ZoeZoe]

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

[Sam_SAS]

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.

[ZoeZoe]

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

should I look at the "group" function?

[Sam_SAS]

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

[ZoeZoe]

Thanks a lot for help.

[SASKiwi]

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

[ZoeZoe]

Does it aggregate and add them to an existing table?