A space for data analytics & AI related technical resources and discussions.
The Text File Import block enables you to import data from a text file, for example a CSV file, into a Workflow. The following shows how to import a CSV file ( basketball_shots.csv ) saved in the Workbench workspace: * Expand the Import group in the Workflow palette, then click and drag the Text File Import block onto the…
The Sort block enables you to order a dataset based on one or more variables. The following demonstrates how to use the Sort block to sort an input dataset lib_books.csv (which contains observations that describe a range of books available from a lending library) using the values in the Author variable: * Import the…
The Select block enables you to keep or discard variables in a dataset. The following demonstrates how to use the Select block to retain the Author variable from the lib_books.csv dataset (which contains observations that describe a range of books available from a lending library): * Import the lib_books.csv dataset onto a…
The Scorecard Model block enables you to create a scorecard model consisting of a set of attributes each with an assigned weighted score (either positive or negative). The following demonstrates how to use the Scorecard Model block to create a scorecard with a logistic regression model and a WoE Transform block. Two input…
The SAS language block enables you to use SAS language functionality supported in Altair SLC which is not available as a discrete block in Workflow. The following demonstrates how to use the SAS language block to filter the input dataset (loan_data.csv, containing observations each of which describes a completed loan and…
The Reject Inference block enables you to address any inherent selection bias in a model by including a rejected population. The block is used to create an inference model and make predictions on loan default using input datasets ( accepted_loans.csvand rejected_loans.csv ) that contains observations describing a loan and…
The Permanent Dataset block enables you to import data from a WPD-formatted file into a Workflow. The following shows how to import a dataset from a file (basketball_shots.wpd) saved in the Workbench workspace: * Expand the Import group in the Workflow palette, then click and drag the Permanent Dataset block onto the…
If you have an LSF cluster, you can connect to it using Altair Analytics Workbench and distribute workloads from your workflow files. To setup the connection you need to: * Select the Altair menu select Link then click New Remote Host Connection to display the New Server Connection window. * Select New IBM Spectrum LSF…
The Excel Import block enables you to import data from a Microsoft Excel Workbook file into a Workflow. The following shows how to import a Worksheet from a Microsoft Excel Workbook ( basketball_shots.xlsx ) saved in the Workbench workspace: * Expand the Import group in the Workflow palette, then click and drag the Excel…
If you find that the default functionality provided in the Workflow Mutate block is not quite what you need, you can create and use custom SAS language functions with the FCMP procedure. User-defined functions saved in a SAS language catalog can be used in a workflow. Functions should not be created in a SAS language block…
There's a wealth of content waiting for you to explore! Need support or have a question? Login or join our community.