Set Operation

A SET dataset forms when you combine two or more input datasets through a set operation. You can also use it as a source for another dataset.

In the following image, a set operation combines customer records from the US_SRC and EU_SRC tables to create a single ALL_CUSTOMERS table that contains customers from both the US and EU sources:

Description of the illustration dasrg-operation.png

Example:

IMPORT SOURCE CUSTOMERS FILTEREDBY (REGION = 'US') AS US_SRC
IMPORT SOURCE CUSTOMERS FILTEREDBY (REGION = 'EU') AS EU_SRC

DEFINE DATASET ALL_CUSTOMERS
 ROWSOURCE UNION[US_CUSTOMERS, EU_CUSTOMERS];
 THIS = US_CUSTOMERS;
 PRIMARYKEY[CUST_ID];
END