This function outputs one or more columns of XML. You can transform the XML to HTML, which is easier to view—see Reports.
The following table is built in the requested Output Database by Logistic Regression scoring. Note that the options selected affect the structure of the table. The table columns in bold comprise the Unique Primary Index (UPI). Also, there may be repeated groups of columns, and that some columns are generated only if specific options are selected.
| Column | Data Type | Description |
|---|---|---|
| Key | Key Column Type | One or more unique-key columns that default to the index defined in the table to be scored (i.e., in tablename). |
| <app_var> | User-Defined | One or more columns as selected under retain. |
| 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 logistic regression model was built. |
| Probability (Default) |
FLOAT | Probability between 0 and 1 that the value of the dependent variable is 1. The name used defaults to “Probability” unless an appropriate column name is entered. Generated only if probability is selected. The default is to not include a probability score column in the created score table. Either the probability score or the estimated value or both must be requested when scoring. |
| Estimate (Default) |
FLOAT | Estimated value of the dependent variable. The default is to not include an estimated value column in the created score table. Generated only if estimate is selected. Either the probability score or the estimated value or both must be requested when scoring. |
Logistic Regression Score Reports
| Report Item | Data Type | Description |
|---|---|---|
| partId | INTEGER | For each batch of XML in the second column that is 31000 bytes, partId is incremented. |
| XmlModel | VARCHAR(31000) | A 31000 byte block of an XML representation of the reports if evaluate or scoreandevaluate are selected. All the reports specified in Model Evaluation appear here. |
To extract the XML into a viewable format, run the following query:
SELECT XMLSERIALIZE(Content X.Dot) as XMLText
FROM (SELECT * FROM "outputdatabase"."outputtablename_txt") AS C,
XMLTable (
'//*'
PASSING CREATEXML(C.XmlModel)
) AS X ("Dot");
Note that there are no evaluation (XML) results if the groupby option is used.