Workflow: Extending Workflow functionality using the SAS Language block

Ian Balanzá-Davis
Ian Balanzá-Davis
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.

Tagged:

Categories