Using SAS LASR Analytic Server Libraries

Default Library

During installation, the SAS Deployment Wizard registers a predefined library for SAS LASR Analytic Server. This library is available for use in the SAS Folders tree, and it is located in /Shared Data/SAS Visual Analytics/Public/Visual Analytics Public LASR.

Input Libraries

When you select a SAS LASR Analytic Server table as an input table for a data query, 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.
  • Instead of using a data query (which transfers the data from the server to the SAS Workspace Server and then performs the join), you can create a LASR star schema. The LASR star schema performs the join in memory with other in-memory tables.

Output Libraries

A SAS LASR Analytic Server library is initially configured as the default output library. When you run a data query, click Visual exploration Explore Results to explore the table immediately.
You can select 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. Instead, for deployments that use HDFS, you can use the data query to append rows, and then save the in-memory table to HDFS.