Calculated Items created in SAS CI Studio: where are the aggregations taking place?

david999 — Wed, 20 Oct 2021 15:54:11 GMT

I would like to know how the calculated items work in SAS. are the aggregations taking place in the SAS compute server or does it send the request to database like SQL passthrough?

Re: Calculated Items created in SAS CI Studio: where are the aggregations taking place?

infomevijay — Thu, 18 Nov 2021 11:14:28 GMT

It depends on the SAS function you have used in the calculated item expression and the database where the data resides. If the function used can be passed to the database by SAS then the computation/aggregation will happen on the database side.
If the function used can not be passed to database by SAS then SAS will download all the data from the table required for the function and calculation will happen on the SAS compute server which is tedious and overhead to the compute server.

Always make sure that the function you are using in SAS can be passed to your database. You can refer to SAS documentation to find out which SAS functions can be passed to your database.

topic Re: Calculated Items created in SAS CI Studio: where are the aggregations taking place? in SAS Customer Intelligence

Calculated Items created in SAS CI Studio: where are the aggregations taking place?

Re: Calculated Items created in SAS CI Studio: where are the aggregations taking place?