SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
irmst_apply_agg.sas File Reference

Apply aggregated values to a target dataset. More...

Go to the source code of this file.

Detailed Description

Apply aggregated values to a target dataset.

Parameters
[in]ds_in_aggA mapping table with aggregated values that can be applied to the target table
[in]ds_in_tgtA table with numeric columns that will be replaced by the aggregated values
[in]ds_in_agg_rules_configA table that provides the mapping between the aggregations and the target table. See aggregation_rules_config ddl for required table structure
[out]out_dsA 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)

Author
SAS Institute INC.
Date
2020

Definition in file irmst_apply_agg.sas.