Using SAS LASR Analytic Server Libraries :: SAS(R) Visual Data Builder 6.2: User's Guide

Default Library

During installation, the SAS Deployment Wizard registers a library for SAS LASR Analytic Server. This library is available for use in the SAS Folders tree, and it is located in

/Products/SAS Visual Analytics Administrator/Visual
                     Analytics LASR

.

Input Libraries

When you select a SAS LASR Analytic Server table as an input table, be aware of the following best practices if the table is large. If the table is not large, then using it for input requires no special considerations.

Here are the considerations for using a large SAS LASR Analytic Server table as an input table:

A WHERE clause is processed in memory by the server if no aggregations or joins are used. Specify a filter on the Where tab so that you use only the rows that you want.
If you want to join the table, then design one query that copies the data to the same library as the table that you want to join it with. Specify a filter on the Where tab, if applicable. Then, design another query that performs the join.

Output Libraries

Using a SAS LASR Analytic Server library for output is common for SAS Visual Data Builder. When you run the query, you can click Visual exploration

Explore Results to automatically select the table and explore it in SAS Visual Analytics Explorer.

You can use the Append data check box on the Properties tab to add rows to an in-memory table. However, this option is not available if you use a SAS Data in HDFS library as a staging library.