PCR Input - Aster Analytics

The following statement creates the input table for the linear regression function. The linear regression function requires the response variable to be in the final column; therefore, strokes must be last in the SELECT list.

CREATE DIMENSION TABLE pcr2 AS 
  SELECT principal_component_1, principal_component_2,
    principal_component_3, strokes 
    FROM pcr1;

This query returns the following table:

SELECT * from pcr2;