Scale Example: ScaleMethod ('midrange'), Intercept (-min) - Teradata Vantage

This example is like Scale Example: ScaleMethod ('midrange') except that the Intercept syntax element has the value -min (where min is the global minimum value). This example also specifies a Multiplier value, but it is the default, as in Scale Example: ScaleMethod ('midrange').

Input

• InputTable: scale_housing, as in Scale Example: ScaleMethod ('midrange')
• Statistic: scale2, created with this statement:

  CREATE MULTISET table scale2 AS (
    SELECT * FROM ScaleMap (
    ON scale_housing
    USING
    TargetColumns ('[2:6]')
    MissValue ('omit')
  ) AS dt ) WITH DATA;

SQL Call

SELECT * FROM Scale (
  ON scale_housing AS InputTable PARTITION BY ANY
  ON scale2 AS statistic DIMENSION
  USING
  ScaleMethod ('midrange')
  Accumulate ('id')
  Intercept ('-min')
  Multiplier (1)
) AS dt ORDER BY id,price,lotsize;

Output

In this example, the intercept syntax element is “-min”. As shown in the description of the Intercept syntax element, in this case the intercept is calculated as:

scaledmin=(minX- location)/scale

The formula for computing the scaled value X' from the input value X becomes:

X'=-scaledmin+multiplier*(X-location)/scale

ScaleMethod is “midrange”, so location and scale are the same as shown in Scale Example: ScaleMethod ('midrange').

 id price               lotsize            bedrooms bathrms stories            
 -- ------------------- ------------------ -------- ------- ------------------ 
  1                 0.0 1.5543175487465182      2.0     0.0 0.6666666666666667
  3 0.32258064516129037                0.0      2.0     0.0                0.0
  4  0.7956989247311828                2.0      2.0     0.0 0.6666666666666667
  5  0.8172043010752688 1.8384401114206128      0.0     0.0                0.0
  6   1.032258064516129 0.6128133704735377      2.0     0.0                0.0
  8  1.1612903225806452 0.6128133704735377      2.0     0.0 1.3333333333333333
  9  1.7978494623655914 0.9693593314763231      2.0     0.0                0.0
 10                 2.0 1.3593314763231197      2.0     2.0                2.0

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.