Workflow: Extending Workflow functionality using the SAS Language block

IanBD
IanBD
Altair Employee
edited October 2022 in Altair RapidMiner

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 person who took the loan) based on the value of a numeric variable Income:

  1. Import the loan_data.csv dataset onto a Workflow using the Text File Import block.
  2. Expand the Code Blocks group in the Workflow palette, then click and drag a SAS language block onto the Workflow canvas.
  3. Click the Output port of the loan_data dataset block and drag a connection towards the Input port of the SAS block.
  4. Double-click the SAS language block to display the SAS language editor view.
  5. In the editor view:
    1. In the Outputs panel, click Add new output dataset.
    2. In the editor, enter the following:
      DATA &Output_1;   SET &Input_1;   IF Income>=50000 THEN OUTPUT; RUN;

  6. Close the SAS language editor and save the configuration when prompted.

A green execution status is displayed in the Output port of the SAS language block and the new Working Dataset. The dataset contains observations from the input loan_data dataset where the income is at least £50,000.