What is the difference between Calculated and Agregate measures in SAS VA?

DavidGQ — Tue, 16 Oct 2018 05:24:06 GMT

What is the difference? When I use one and other?

Thanks.

Re: What is the difference between Calculated and Agregate measures in SAS VA?

FredrikE — Tue, 16 Oct 2018 07:37:13 GMT

I think of calculated measures as one per row in the data.

Aggregated on the other hand are done on aggregated level on a bunch of rows.

As an example:

If I create a calculated measure with a ratio it will calculate the ratio on each row and therefore is not possible to aggregate.

In this case I use a aggregated measure instead calculating the ratio on the aggregated level.

Does it make it clearer for you 🙂 ?

//Fredrik