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:
-
Microsoft Excel spreadsheets
-
-
-
-
Facebook, Google Analytics, and
Twitter
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:
-
-
append entire in-memory tables to another in-memory table
-
save in-memory tables to SASHDAT for
persistence and fast reloads