Apply aggregated values to a target dataset. More...
Go to the source code of this file.
Apply aggregated values to a target dataset.
[in] | ds_in_agg | A mapping table with aggregated values that can be applied to the target table |
[in] | ds_in_tgt | A table with numeric columns that will be replaced by the aggregated values |
[in] | ds_in_agg_rules_config | A table that provides the mapping between the aggregations and the target table. See aggregation_rules_config ddl for required table structure |
[out] | out_ds | A table with the same structure and row count of the target table but replaced with aggregated values inserted into the aggregation column(s) |
This macro reads in 3 tables: a mapping table of aggregations, a target table and a table that contains aggregations to be inserted into the target table. If a row in the target table does not match any of the aggregations, it will have a blank value in its aggregation column(s)
Definition in file irmst_apply_agg.sas.