The following table is built in the requested Output Database by Linear Regression scoring. Note the following considerations when viewing the table:
- The options selected affect the structure of the table.
- The columns in bold comprise the Unique Primary Index (UPI).
- There may be repeated groups of columns.
- Some columns are generated only if specific options are selected.
| Column | Data Type | Description |
|---|---|---|
| Key | User-Defined | One or more unique-key columns that defaults to the index defined in the table to be scored (that is, in tablename). The data type defaults to the same as the scored table, but can be changed using Primary Index Columns. |
| <app_var> | User-Defined | One or more columns as specified with the retain parameter. |
| Groupby Variable | User-Defined | A column is generated for each groupby column. Within each column there are distinct values of the groupby columns for which a linear model was built. |
| <dep_var> (Default) |
FLOAT | If scoringmethod is score or scoreandevaluate, the name of the predicted value column can be entered using the predicted parameter. If not entered, the name of the dependent column in the input table is used. |
| residual_column_name | FLOAT | [Column appears only if scoringmethod=scoreandevaluate.] Residual values of the evaluation, the difference between the estimated value and the actual value of the dependent variable. |
In addition to the table specified by outputdatabase.outputtablename, a result set is returned from the XSP. If groupby columns were specified, columns are created for each and populated with the distinct values for which the linear model was built. The minimum, maximum, average, and standard error of estimate as described in Evaluation are also returned as a result set or in "outputdatabase"."outputtablename_txt" if specified.