- ScaleMethod
- Specify one or more statistical methods to use to scale the data set. For method values and descriptions, see Location and Scale for Statistical Methods.
If you specify multiple methods, the output table includes the column scalemethod (which contains the method name) and a row for each input-row/method combination.
- MissValue
- [Optional] Specify how the ScaleByPartition function is to process NULL values in input:
Option Description KEEP (Default) Keep NULL values. OMIT Ignore any row that has a NULL value. ZERO Replace each NULL value with zero. LOCATION Replace each NULL value with its location value. - TargetColumns
- Specify the input table columns that contain the values to scale. The columns must contain numeric values must between -1e308 and 1e308. If a value is outside this range, the function treats it as infinity.
- GlobalScale
- [Optional] Specify whether all input columns are scaled to the same location and scale.
- Accumulate
- [Optional] Specify the input table columns to copy to the output table.Tip: To identify the sequences in the output, specify the partition columns in this syntax element.
- Multiplier
- [Optional] Specify one or more multiplying factors to apply to the input variables (multiplier in this formula):
X' = intercept + multiplier * (X - location)/scale
- Intercept
- [Optional] Specify one or more addition factors incrementing the scaled results—intercept in this formula:
X' = intercept + multiplier * (X - location)/scale