Create Scoring Output Tables

What Is a Scoring Output Table?

A scoring output table is a SAS data set that contains the data from executing a scoring task. The scoring output table cannot be a database table. You can provide a scoring output table or you can create a scoring output table definition using SAS Model Manager. When you create a scoring task, you specify either the scoring output table that you provide or the scoring task output definition as the scoring task output table.
A SAS data set that you provide as a scoring output table must be registered to the SAS Metadata Repository or a libref must exist in the Data Sources category view for the library where the data set resides.
You create a scoring output table definition by using the Create Output Table function directly from the model. In the Create Output Table function, you select variables from a scoring task input table as well as variables from the model’s output. The variables in the Input Variables table are variables from the scoring task input table if one is specified for the Default Scoring Task Input Table property for a project, version, or model property. Otherwise, the Input Variables table is empty. The Output Variables that appear in the window are model output variables. You use the variables from both tables to create the scoring output table.
SAS Model Manager saves the table definition as metadata in the SAS Metadata Repository. The location of the metadata is defined by the SAS library that you specify when you create the output table definition. After SAS Model Manager creates the table definition, the table can be selected as the output table for subsequent scoring tasks.
You can view a scoring output table definition on the SAS Folders tab of the Data Sources category view. If you do not see the table, right-click the library name and select Refresh.
When you execute a scoring task with a type of Test, the output table is located under the scoring task node in the Project Tree. If the scoring task type is Production, the output table is stored at the designated SAS library location that you specified in the Create Output Table window.

How to Create a Scoring Output Table Definition

To create a scoring output table definition, follow these steps:
  1. In the Project Tree, navigate to the Models folder.
    MMRootthen selectorganizational folderthen selectproject folderthen selectversion folderthen selectModels
  2. Right-click model name and select Create Output Table from the pop-up menu.
    Create Output Table
    Note: If no value for the model property Default Scoring Task Input Table is specified on the Properties tab, the Input Variables section is empty.
  3. Enter a name for the output table definition that is unique to the SAS library. The names in the Library selection list are the SAS libraries that are defined in the SAS Metadata Repository under the Data Library Manager folder in SAS Management Console. The name can contain letters and the underscore ( _ ). Spaces and special characters are not allowed.
  4. Select a SAS library name from the Library list.
    Note: You must have Write access to the SAS library.
  5. Select the check boxes in the Keep column for the input and output variables that you want to include in the output table definition.
    Note: If you want to use all of the variables in the output table definition, you can click Add All instead of selecting individual variables. If you use Add All and you want to use the project output variable names in the scoring table instead of the model variable names, click Use Project Mappings before you click Add All.
  6. Select the Add model ID check box to add the ModelID variable to the output table definition. The model UUID appears in all rows of the output table.
  7. Select the Use Project Mappings check box to use the project's output variable names in the output table definition for model variables that are mapped to project variables.
    Note: If you want to use all of the variables in the output table definition and you want to use the project output variable names in the scoring table instead of the model variable names, click Use Project Mappings before you click Add All.
  8. Add the columns to the output table using one of these methods:
    • Click Add Columns to add the individual column information from each row that you selected in the Input Variables table and the Output Variables table.
    • Click Add All to add all the columns in the Input Variables table and all the variables in the Output Variables table.
    Note: To clear your output table definition selections, click Remove All.
  9. Click OK. The output table definition is created and you receive a confirmation message. Click Close to close the confirmation message.
    Note: You can view the output table definition in the SAS Folders tab or the SAS Libraries tab of the Data Sources category view. You might need to right-click the library name and select Refresh to see the table definition.

See Also

Overview of Scoring Tasks
Project Tables
Copyright © SAS Institute Inc. All rights reserved.