What Is SAS Visual Data Builder?

The data builder enables analysts and data administrators to perform basic data preparation. You can create data queries to perform joins, add calculated columns, and subset and sort data. Several productivity features accelerate the creation of columns based on common aggregation functions.
Once you create your data queries, you can reuse them as subqueries for more sophisticated data queries, export them as jobs for scheduling, or schedule them directly from the user interface.
The data builder has self-service data import features that enable you to access data from the following data sources:
After you import the data, you can prepare it for analysis or join it with existing data.
The data builder provides a series of features that take advantage of the in-memory tables in SAS LASR Analytic Server.
You can perform the following operations to add data to memory in the server:
  • load an existing table directly into memory
  • load the results of a data query into memory (or stage the data and then load it into memory)
After the data is in memory, you can perform the following operations with in-memory tables:
  • join in-memory tables to form a LASR star schema
  • append entire in-memory tables to another in-memory table
  • save in-memory tables to SASHDAT for persistence and fast reloads