In the case where your data already includes unstructured text that you want to analyze,
the data builder can add a unique numeric key as a column in the table. For example,
many data tables include a text column for comments. Using
text analysis, you can look for trends or themes within these comments. The text analysis in SAS
Visual Analytics requires a unique numeric key to reference the
data sources.
To add a unique numeric
key to a table:
-
-
Add the columns to include in the text analysis by clicking the column name in the
table in the
workspace.
-
In the
Column
Editor, right-click on the first row in the table, and
select
Add Generated Key Column.
A column that is named GENERATED_ID is
added to the table.
-
-
Save and run the data query.
When you run the data query, the
GENERATED_ID column begins at zero and increments for each row in the
source table. If you select the
Append data check box on the
Properties tab, then the data
query increments from the current maximum value.
If
the data that you want to use is already in memory on SAS LASR Analytic Server,
then performing the previous steps results in the following sequence
of data movements:
-
The
data is read from memory on SAS LASR Analytic Server and transferred
to the SAS Application Server.
-
The data query runs and adds the generated key column.
-
The
data is transferred back to SAS LASR Analytic Server in a
new table.
You can avoid
these data movements by adding the generated key column before loading
the table to memory on SAS LASR Analytic Server.